Unanswered: Need help cascading combo boxes using a junction table
I'm really hoping someone can answer this for me, I've been trying to figure it out for 2 days.
I have a Production Data form for users to input their end of shift information into. I would like them to populate the Machine combo box then in turn the Tool combo box would only show the tools used on that machine.
I have a Machine table (macMachine, macDesc), Tool table (tlToolNum, tlToolDesc, tlMinutes/Shift, tlPieces Per Hour, tlCycleTime) and MachineTool (macMachine, macDesc, tlToolNum, tlToolDesc) table for the many-to-many relationship.
I can't figure out how to populate the combo boxes to get the desired results.