Search code examples
databasefilemakermailing-list

File Maker Pro 12: Possible to flag/remove matched fields from separate table?

Hi all. My first question here (after much googling/searching).

I am working on migrating a plethora of mailing list spreadsheets to a simple database, using File Maker. One stumbling block is - I need to be able to flag records as inactive, based on if their address exists in a separate table.

ie. To keep it simple:

  • table1 has name, address, and zip.
  • table2 has address and zip.
  • If an address/zip combination in table1 exists also in table2, then it needs to be flagged in table1 as inactive.

Thanks in advance.

Solution

  • First I would create a calculated field called something like addressZIP that combines address and ZIP into a single string.

    Then, in table 1, create a calculated field.

    Enter this

    If (IsEmpty ( FilterValues ( List ( table2::addressZIP ) ; addressZIP )),"","FLAG").

    I think that will work, but I'm not positive. I'm not at a computer with FM right now so I can't test it.