AnsweredAssumed Answered

Conditional Value List Limiting Relationships

Question asked by dwismi on Oct 24, 2011
Latest reply on Oct 24, 2011 by philmodjunk

Title

Conditional Value List Limiting Relationships

Post

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!

Outcomes