I have 2 databases.
1 MASTER and 1 portion of that list that I have called to update the records.
I want to now merge & update the records in to the Master that I have updated.
The key reference is the phone number as this never changes. If a field has been left blank in the updated portion, I want the MASTER to then update with a blank field, not leave what may currently be in there.
How can I do this using Filemaker Pro?