I am brand new to FMP so please be patient with me. I'm trying to import data from fields in one database to a second using lookup to find related entries in both. (I'm trying to get the address from db1 to db2, both have first name and last name that I will compare to figure out which to transfer) I'm trying to create a "match field" based upon a support article I found [http://help.filemaker.com/app/answers/detail/a_id/5244/kw/lookup%20values] using the calculated value outlined (FullName (calculation, text result)=FirstName & "^" & LastName). But after defining the field nothing happens. Do I need to do something to populate the field?
Thanks in advance for any help you can provide