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????