Conditional Value List Limiting Relationships
I am using Filemaker v11. i have a database for managing vehicle cost savings ideas. I am using a conditional value list so when I select the Fiscal Year, the Vehicle Model list is filtered to only models of that year. The two tables I am working with are Idea Entry and Vehicle Volumes. My relationship is for fields Fiscal Year to Fiscal Year in these two tables. The conditional value list works with this relationship except when I select the year it grabs the volums from the first record that matches that year. If I add other fields to the relationship the conditional value list breaks and the Vehicle Model displays "<no values defined>". In the Ideas Entry layout, I need it to allow me to select the Fiscal Year, then the Vehicle Model, then pull in other fields such as volumes from the Vehicle Volumes records.
Any help would be greatly appreciated!