Zydeceltico
Registered User.
- Local time
- Today, 13:44
- Joined
- Dec 5, 2017
- Messages
- 843
Hi All -
I have a junction table called tblInspectionEvents.
It has fields Inspection_ID, DateTime, and InspectionType. I have a form called frmInspectionEvents that is based on tblInspectionEvents.
I have several tables that record data for a different kinds of inspections (e.g., tblWeldTests, tblAssemblyInspections, tblMillInspections, etc.).
On frmInspectionEvents, I would like to have combo box bound to InspectionType. When the user clicks the combo box, I would like to present the user with a drop down containing: "weld test," "assembly inspection," "mill inspection," etc.
When the user makes a selection I would like an inspection form open that is based and bound to the corresponding table. For instance, if the user were to select "weld test" from the dropdown menu, frmWeldTest would open for data entry. When the user saves the new data in frmWeldTest a record would be created in both tblWeldTest and also in tblInspectionEvent.
Is this possible?
Thanks,
Tim
I have a junction table called tblInspectionEvents.
It has fields Inspection_ID, DateTime, and InspectionType. I have a form called frmInspectionEvents that is based on tblInspectionEvents.
I have several tables that record data for a different kinds of inspections (e.g., tblWeldTests, tblAssemblyInspections, tblMillInspections, etc.).
On frmInspectionEvents, I would like to have combo box bound to InspectionType. When the user clicks the combo box, I would like to present the user with a drop down containing: "weld test," "assembly inspection," "mill inspection," etc.
When the user makes a selection I would like an inspection form open that is based and bound to the corresponding table. For instance, if the user were to select "weld test" from the dropdown menu, frmWeldTest would open for data entry. When the user saves the new data in frmWeldTest a record would be created in both tblWeldTest and also in tblInspectionEvent.
Is this possible?
Thanks,
Tim