AnsweredAssumed Answered

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

Question asked by disabled_dconnect on Jan 11, 2014
Latest reply on Jan 13, 2014 by disabled_dconnect

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 :)

Outcomes