Title
Multiple value lists
Post
Hello,
I have a form layout with 4 drop down boxes to show items from 4 fields that are in the same table. This is in FileMaker Pro 11.
Instead of using the actual field names, I will call the field names A, B, C, D.
Fields A, B, C, D all have duplicate entries. They are all text fields with 'indexed, Unique, Allow override'. They are all part number fields and the entries could include numbers, letters, forward and reverse slashes, dashes.
I want to find the items from D field based on user selections of respective items from A, B, C.
A drop down box will list all items from the A field. User will select 1 item.
B will list items from the B field that depend on the item selected in A. User will select 1 item.
C will list items from the C field that depend on the item selected in A and depend on the item selected in B. User will select 1 item.
D will list items from the D field that depend on the item selected in A and depend on the item selected in B and depend on the item selected in C.
I appreciate your help on this.
Thank You
This is what I call a Hierarchical Conditional Value List. I have a file that demonstrates 3 different versions of this amongst a set of 10 different CVL examples.
But the file is in .fmp12 file format and must be opened in FileMaker 12 or newer, 13 or newer recommended.
And two of those examples use ExecuteSQL--a function that does not exist in FMP 11. The 3rd example works equally well in older versions of FileMaker as it relies on a set of relationships.
So you could download the 30 day free trial of FileMaker 14 and use it to open the following file to see how the first Hierarchical Conditional Value list example is set up.
"Adventures in FileMaking #1 - Conditional Value Lists"