I have a scenario where I’m assigning users and machines to a project.
This is done through a form and subform. The user selects the project and a week commencing date on the main form and can then assign a machine and a user on the subform.
User and Machine are separate comboboxes.