When using Database lookup key the lookup key value does not get written to the field. The other values do get written.
Limitation of design
- Workaround is to add another extra field called (for example) DocID which is looked up and is actually the same field used for looking up. A dummy field so to speak.
- For example you would then have fields pk_1, t1,t2.
- Values for pk_1 will not get written to the field. Create an additional field called DocID. Use the value for pk_1 as the lookup field for DocID.
- DocID would be filled in with the value of pk_1 during the lookup. The same as the look up of t1 and t2 would be filed in with their coresponding values.
5.0 Service Pack 7; 6.0 Service Pack 1; 6.0 Service Pack 2; 6.0; 6.1; 6.1 Service Pack 1; 6.1 Service Pack 2; 6.2; 6.2 Service Pack 1; 6.2 Service Pack 2
Article is closed for comments.