6 Replies Latest reply on Jan 13, 2014 9:01 AM by disabled_dconnect

    Is this possible? Comparing two tables checkboxes fields and creating a result of all matches

      Title

      Is this possible? Comparing two tables checkboxes fields and creating a result of all matches

      Post

           I have two tables "clients" and "customers" related using the "city" field.

           I have a field called "market" on both tables and I've entered the data using a checkbox.

           I want FM to compare the field in both tables for related "clients" and "customers" and tell me which values are in both, e.g.,

           a client in London has a "market" field with the boxes "education" "sport" "health" and "offices" checked

           and a customer in London has a "market" field with the boxes "marine" "sport" "transport" and "offices" checked

           after comparing the "market" field of both records, FM would create the result: "sport" and "offices"

           I've been wondering if this is possible for a few days, so I thought I would ask the forum.

           Thanks :)