AnsweredAssumed Answered

Looking up field data from a different FMP file ... Help !!

Question asked by bobatkinson on Jan 18, 2012
Latest reply on Jan 19, 2012 by bobatkinson

Hello;

 

This may seem simple, but I'm a relative beginner and stumped. I have two different FMP 10 files which have the same fields. One of them (A) has missing data in several fields across all the records, The other file (B) has all the data for those fields. I can use my AccountNumber field to match records between the two files and I want to do a one-time Lookup to grab the data in several fields from file B into the empty fields in matching records (by AccountNumber) in A.

 

HOW DO I DO IT????

 

Thanks.

Outcomes