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.
Thank you for the information. I will download FM 14 and look at the 3rd example.
I am having an IT issue with loading software to a company PC so I may be only able to use FM Pro 11 that is currently running.
Any suggestions with the limitations of only able to work with FM Pro 11 would be appreciated.
Do you have a computer that you can use at home?
I spent days putting together that file and hours of that were on HVL's so I'm a bit reluctant to try and replicate all that in a text format here in the forum.
Yes, I will try to get another computer.