1 Reply Latest reply on Jan 11, 2010 1:42 PM by philmodjunk

    Help with self-join relationship for a value list.

    justinkwithj

      Title

      Help with self-join relationship for a value list.

      Post

      Help with self-join relationship for a value list.

      Hi community, I'm using FMP 10 and am making a database for a foreign language dictionary.  I'd like to have a value list filtered in a specific way but am having trouble.

      I have the main "dictionary" table and then also a "part of speech" table, with a join table between them (a many to many relationship). 

      I would like to make a value list that shows all records from the main dictionary table that are of a specific part of speech.  Example: I'd like a value list that would display all of the records that are classified as a root verb.  Also, this filter is constant and I won't need to change it to show a different part of speech.

       

      Thanks in advance for any help.