I have to build a machine inspection database. Right now I have:
Table 1: Machine_Info
MachineID(PK)
SerialNo
Make
Model
Type
Location
Table 2: Components:
CompID(PK)
Machine_Make (looked up from Machine_Info)
Machince_Model (looked up from Machine_Info)
Comp_Group
Comp_Item
Table 3: Inspection
InspNo(PK)
MachineNo (looked up from Machine table)
InspDate
InspBy (looked up from an employee database tied to HR)
Table 4: Inspection_Detail
InspNo (looked up from Inspection table)
CompID (looked up from Components)
Pass (Yes/No)
Comments
Because we have so many different machines, and each machine may have different components depending on it's configuration, make, model etc, the plan is to create a form that will record the info for the Inspection table. On that form will be a subform that will enter and record the info for the Inspection Detail table.
I am trying to figure out how to make the sunform dynamically add the necessary fields. If MachineID 1 has:
Group: Moving Parts
Components: pully, wheel, gear
Group: Still Parts
Components: legs, frame, window
then when MachineID 1 is selected in the main form, only, but all, the necessary groups and components that belong to that machine are populated on the form.
After the information is entered I need a button that will cycle through each component and add it to the Inspection_Detail table.
If I am not clear in what I need please ask specific questions, as I am still trying to work this out.
----
Access 2002 on a mixed Windows OS network.
Table 1: Machine_Info
MachineID(PK)
SerialNo
Make
Model
Type
Location
Table 2: Components:
CompID(PK)
Machine_Make (looked up from Machine_Info)
Machince_Model (looked up from Machine_Info)
Comp_Group
Comp_Item
Table 3: Inspection
InspNo(PK)
MachineNo (looked up from Machine table)
InspDate
InspBy (looked up from an employee database tied to HR)
Table 4: Inspection_Detail
InspNo (looked up from Inspection table)
CompID (looked up from Components)
Pass (Yes/No)
Comments
Because we have so many different machines, and each machine may have different components depending on it's configuration, make, model etc, the plan is to create a form that will record the info for the Inspection table. On that form will be a subform that will enter and record the info for the Inspection Detail table.
I am trying to figure out how to make the sunform dynamically add the necessary fields. If MachineID 1 has:
Group: Moving Parts
Components: pully, wheel, gear
Group: Still Parts
Components: legs, frame, window
then when MachineID 1 is selected in the main form, only, but all, the necessary groups and components that belong to that machine are populated on the form.
After the information is entered I need a button that will cycle through each component and add it to the Inspection_Detail table.
If I am not clear in what I need please ask specific questions, as I am still trying to work this out.
----
Access 2002 on a mixed Windows OS network.