1 Reply Latest reply on Feb 7, 2014 4:23 PM by philmodjunk

    Value List from Contacts::Name Where Contacts::Type = "Employee"

    rh

      Title

      Value List from Contacts::Name Where Contacts::Type = "Employee"

      Post

           HI all

           I'm using a Value List showing results from Contacts::Name Where Contacts::Type = "Employee"

           The above is simple in SQL but in Filemaker, the closest thing I can find is a value list that returns names from Contacts::Name  when Contacts::Type = Matches::Employee

           or Matches::Company or Matches::Customer

           This works for record number one only. The rest of the records show an empty value list in the dropdown because my matches table on has one record.

           The alternative seems to be to set all the fields in table Matches to Global, but a shared Filemaker files does NOT save Global fields, meaning I have to repopulate the fields in the Matches table every time a user opens the file (possibly with a script?)

            

           Why do I even have to use a matches table for this?

           Am I missing something simple?