Calculated Fields as look up keys

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
mbentote
Posts: 3
Joined: Tue Oct 10, 2017 12:44 pm

Calculated Fields as look up keys

Post by mbentote » Thu Mar 17, 2011 5:11 pm

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
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> Calculated Fields as look up keys

Post by kfleming » Tue Mar 22, 2011 7:44 am

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

Post Reply