I am trying to create a form with a number of Combo Boxes which look at the same 'single-field' list. The list might contain up to say 20 items and there could be 5 combo boxes.
The selection criteria are:
If an item is chosen in cbox1 (say Item3), it should not then appear in the list shown for cbox2.
If an item is then chosen in cbox2 (say Item5), then neither Item3 nor Item5 should appear in the list for cbox3.
And so on for the other boxes.
I have seen threads which filter another field depending on what is chosen ia a combo box but have not found one which only has one field where the number of items available to choose reduces as each combo box is filled. An analogy would be a shopping list of 20 items but you are only choosing five unique items from the list in sequence.
I could probably create filters for what's not in (Cbox1), then whats not in (cbox1 and cbox2), then whats not in (cbox1 and cbox2 and cbox3) and so on but after five or six boxes it gets a bit cumbersome.
I was wondering if there was a more elegant solution available which would allow for a larger number of cboxes.
The selection criteria are:
If an item is chosen in cbox1 (say Item3), it should not then appear in the list shown for cbox2.
If an item is then chosen in cbox2 (say Item5), then neither Item3 nor Item5 should appear in the list for cbox3.
And so on for the other boxes.
I have seen threads which filter another field depending on what is chosen ia a combo box but have not found one which only has one field where the number of items available to choose reduces as each combo box is filled. An analogy would be a shopping list of 20 items but you are only choosing five unique items from the list in sequence.
I could probably create filters for what's not in (Cbox1), then whats not in (cbox1 and cbox2), then whats not in (cbox1 and cbox2 and cbox3) and so on but after five or six boxes it gets a bit cumbersome.
I was wondering if there was a more elegant solution available which would allow for a larger number of cboxes.