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.
+18The 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.