Forum Discussion

HarryWright's avatar
HarryWright
Qrew Member
8 years ago

Limit Multi-select picks to one in linked table

I have a table with employees and their details, including a multi select for their function(s). In another table I have a roster where each person can be assigned a roster shift. As some ...
Forms
Formulas and functions
Relationships
MeredithMoore5's avatar
MeredithMoore5
Qrew Assistant Captain
8 years ago
It is set up properly for the a basic dropdown to work and show only the related lot numbers. However, it gets complicated as they run several batches, and each batch can have several ingredients, and many lots per ingredient. I would have way too many single drop downs. If I could just have a multi-select for each ingredient, it would solve all my problems.