1 Reply Latest reply on Jun 3, 2010 6:06 AM by ryan

    Database Importing

    Jill

      Title

      Database Importing

      Post

      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?

        • 1. Re: Database Importing
          ryan

          In your MASTER file, click on File, then Import Records, then File.

           

          Find/browse your Updated fmp file/database. 

           

          In the 'Import Field Mapping' window, towards the bottom, select 'Update Matching Records in Found Set'.

          match up the fields you want to update in the Master file by changing the symbol between them to an arrow --->

           

          As you said the Phone number seems to be each records "unique id", set the symbol between the phone number fields to an Equals sign =

           

          With the test i ran, the new/updated blank fields should overwrite/replace the populated fields in the Master db.