asked on

Excluding previous choices from dropdowns based on a table.

Have attached a sample database. When you click on the main switchboard - click on Batch. This opens the Batch form which is based on the Heat treat table. How can I modify the dropdowns in this form so that when Workorder 1 is selected - it offers in the combo box a list of all the workorders that relate to that workcentre? Then when the user moves to Workorder2, the dropdown they select will only reflect the workorders that are left e.g. if I have workcentre 123. That has 5 workorders: 10,11,12,13,14. When I choose 10 from this dropdown in workorder 1, the only choices that are left in workorder 2 are: 11,12,13,14. And when I go onto Workorder 3, the only choices I have left are what is left i.e. 12, 13, 14.
EE_sample_workorders_vers_01.accdb

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

agwalsh

ASKER

Take your point on board. I did ask about the normalised design. Apparently there will only ever be 5 choices so that's why it's done that way. I also noticed the batch and heat treat stuff. Apparently the reason why the combo boxes were chosen was because they were to be prioritised i.e work order 1 to be done before work order 2. I have already suggested to him that maybe he add an extra field for each one e.g. work order 1 combo box has a work order 1 field assigned a default value of 1. But will follow up on the raw data question. Thanks for your help so far.

SOLUTION