Help

Choosing a Multiselect Option More Than Once?

Topic Labels: Base design Data
695 1
cancel
Showing results for 
Search instead for 
Did you mean: 
merrymbushman
4 - Data Explorer
4 - Data Explorer

Is there a way to choose a multi-select option more than once? For example, if I have a list of A, B, C, D for a job, and that job requires 3 A's and 2 C's, is there a way to choose those options in the multi-select more than once? Right now I can only choose A once and C once. 

1 Reply 1

The best way to capture a tally of unique associations (such as in a multi-select) is using a junction table approach.
You would have three linked tables setup with linked record fields as:
Table1 (unique list) <-> Table2 (junction table) <-> Table3 (unique list)
Table2 could store information about the relationship between table1 and table3, such as a tally.

Hope that helps!