3 Replies Latest reply on Feb 21, 2017 8:00 AM by philmodjunk

    Comparing 2 tables

    Phil_Mac

      I have a master parts table and trying to match it with a imported table. I want to remove all the records in the imported table that doesn't match up with the master parts table,

       

      Phillip

        • 1. Re: Comparing 2 tables
          TSPigeon

          Phil_Mac:

           

          Thank you for your post!

           

          I'm going to move this thread from the FileMaker Community Feedback Space, which is specifically for input on the Community itself, to the Discussions Space where you should receive more views and potentially more feedback on this topic!

           

          TSPigeon

          FileMaker, Inc.

          • 2. Re: Comparing 2 tables
            coherentkris

            Alot depends on the structure of both tables.

            The ideal setup would be if the master parts table and the import table both have part ID primary key.

            if this is true then a simple not equal relationship will allow detection of not matching records from either side of the relationship. If this is not the case then we need to know more about the structure of both tables

            • 3. Re: Comparing 2 tables
              philmodjunk

              Assuming that same unique part ID (primary key), you can set up a relationship using the default = operator and then do the following:

               

              put the part ID field from the master parts table on your import table layout.

               

              Enter Find Mode and enter an asterisk into that field.

               

              Select the Omit option and perform the find.

               

              Your found set thus produced will be all records in the import table that do not match to a record in the master parts table.