Conditional Value List
I tried using PhilModJunk's advice with this user who seems to have the same problem as me! I followed his instructions to a T and yet I am not getting the results I want. This is the link http://forums.filemaker.com/posts/1ebc83718f .
Tables: Inventory 3 and Purchase Orders.
Relationships: Type in both Inventory 3 and PurchaseOrders. Item in both Inventory 3 and PurchaseOrders 2. Category_Shop in both Inventory 3 and PurchaseOrders 4.
Drop down list for Type works. Drop down for Category_Shop works. But the drop down ITEM list only shows items in the same department and ignores the category_shop step. What did I miss?