AnsweredAssumed Answered

Multiple value lists

Question asked by Trackfrc on Jun 23, 2015
Latest reply on Jun 23, 2015 by Trackfrc

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

Outcomes