ingredlee

How do I use a relationship to filer a pick list

Discussion created by ingredlee on Jun 30, 2013
Latest reply on Jul 3, 2013 by ingredlee

I have an application where items in a table have a relationship to other items in the same table. This relationship is formed by an intersection table that has the primary key fo each item plus a comment about the relationship. I've created a pick list that contains all items in the main table when an item is picked from the list a new row in the intersection table is created. I would like the pick list to show only items that do not already have a relationship with each other. I have tried may iterations without success. I can get a list of the items I want to filter out. But everytime I try to apply that to the pick list, I am unsuccessful. I am quite experienced with SQL Server. But sometimes I struggle in trying to translate that to FileMaker relationships. Any help will be much appreciated.

Outcomes