I have a table with employees and their details, including a multi select for
In another table I have a roster where each person can be assigned a roster shift. As some employees have multiple functions assigned to them, I want to be able to specify when they are put on a shift what function they are doing (out of the ones previously assigned to that employee from the multi-select in the employee table).
At this stage if they have multiple functions selected in the employee table they all show in the roster shift record.
Thanks in advance
The only other option would be to add the same multi-select field to the roster allowing you to specify which functions are needed for that shift. Then set up a way to 'check' the functions on the roster against the employee's functions and prevent the record from being saved if there is a mismatch.
I have Lot #'s (a lot of them). I have hundreds of inventory items (flavor powders) and each one of the flavor powders have many lot numbers.
Example: Ingredient Inventory of Sherbet Flavor Powder of 60kg. That inventory may have 3 Lot #'s -
If I choose Sherbet Flavor Powder in my ingredient list (for a recipe), and I need 35kg, I will be using 2 lot numbers.
I would like only the Sherbet Flavor Powder Lot #'s show in the multi-select.
If your ingredient/lot number relationship is many to many (ie. a lot number can be associated up to more than one ingredient, as opposed to lot numbers being strictly child records to the records on the ingredients table), it gets a little stickier, but I think you'd still start with a lot number table, do the standard many-to-many technique to a joined ingredient/lot number table and then work from there.