Calculated Fields as look up keys

[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

[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