5 Replies Latest reply on Jun 23, 2015 2:09 PM by Trackfrc

Multiple value lists

Trackfrc Jun 23, 2015 10:55 AM

Title

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

1. Re: Multiple value lists

philmodjunk Jun 23, 2015 11:03 AM (in response to Trackfrc)

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"
Like Show 0 Likes(0)

Actions
2. Re: Multiple value lists

Trackfrc Jun 23, 2015 11:41 AM (in response to Trackfrc)

Thank you for the information. I will download FM 14 and look at the 3rd example.
Like Show 0 Likes(0)

Actions
3. Re: Multiple value lists

Trackfrc Jun 23, 2015 11:50 AM (in response to Trackfrc)

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.
Like Show 0 Likes(0)

Actions
4. Re: Multiple value lists

philmodjunk Jun 23, 2015 1:33 PM (in response to Trackfrc)

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.
Like Show 0 Likes(0)

Actions
5. Re: Multiple value lists

Trackfrc Jun 23, 2015 2:09 PM (in response to Trackfrc)

Yes, I will try to get another computer.

Thanks
Like Show 0 Likes(0)

Actions

Go to original post