Page 1 of 1

Calculated Fields as look up keys

Posted: Thu Mar 17, 2011 5:11 pm
by mbentote
I need to read a table and generate a look up key as a calculated field to another table. When I use the calculated field as the look up key it does not find a record in the second table although the key is valid. Help!__Many Thanks

=> Calculated Fields as look up keys

Posted: Tue Mar 22, 2011 7:44 am
by kfleming
Are you sure that the calc field is an exact match to the related table index? Have you tried changing the match length to partial and experimenting with the number of characters to match?____Kathleen__R&R Support