Limit Select Options with Permissions? (Multiselec...

[merrymbushman]

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. 

[Stephen_Orr1]

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!