AnsweredAssumed Answered

Help with self-join relationship for a value list.

Question asked by justinkwithj on Jan 11, 2010
Latest reply on Jan 11, 2010 by philmodjunk

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.





Outcomes