Zydeceltico
Registered User.
- Local time
- Today, 15:36
- Joined
- Dec 5, 2017
- Messages
- 843
Hi All -
I have a DB to perform various inspections of products coming off our various manufacturing lines.
I have a main table (tblInpsectionEvent) that stores general data about a given inspection (e.g., Date/Time, Job Number, Inspector's name, etc.).
I then have four sub-inspection tables. There is no redundancy of fields across tables. Each table has approximately ten fields that are 110% unique to the area of activity reflected in one of the four inspection tables.
All of these tables have their own forms and primary keys.
There are four command buttons on the main inspection to open one of the four sub-inspection forms.
The PK of the main inspection table is passed as a foreign key to whichever sub-inspection form/table is opened.
There is always a sub-inspection ID associated with an InspectionEvent ID.
There is a 3rd table and form called Line Stop which only is opened and a record written in the infrequent circumstance when a mill line, welding line, fabrication line, or paint line stops running for whatever reason.
So here's the big question: I cannot wrap my mind around how to relate/link/access table or form Line Stop from an inspection/sub-inspection combined event given that I have four sub-inspections.
When form Line Stop is opened it is important to relate it to the current InspectionEvent and it's sub-inspection record also.
I've tried relating tblLineStop to the other tables directly several different ways and then playing with the forms/reports to see if I can get where I want but I'm just getting frustrated.
Ultimately I would like to have a row somewhere in some table that records FKs for the InspectionEvent_PK, a sub-inspection FK(e.g., InspectMill_FK), and LineStop_PK (or FK depending on design) - - - - but I cannot figure out how to make it work.
Thanks for any and all thoughts and insights!
Tim
I have a DB to perform various inspections of products coming off our various manufacturing lines.
I have a main table (tblInpsectionEvent) that stores general data about a given inspection (e.g., Date/Time, Job Number, Inspector's name, etc.).
I then have four sub-inspection tables. There is no redundancy of fields across tables. Each table has approximately ten fields that are 110% unique to the area of activity reflected in one of the four inspection tables.
All of these tables have their own forms and primary keys.
There are four command buttons on the main inspection to open one of the four sub-inspection forms.
The PK of the main inspection table is passed as a foreign key to whichever sub-inspection form/table is opened.
There is always a sub-inspection ID associated with an InspectionEvent ID.
There is a 3rd table and form called Line Stop which only is opened and a record written in the infrequent circumstance when a mill line, welding line, fabrication line, or paint line stops running for whatever reason.
So here's the big question: I cannot wrap my mind around how to relate/link/access table or form Line Stop from an inspection/sub-inspection combined event given that I have four sub-inspections.
When form Line Stop is opened it is important to relate it to the current InspectionEvent and it's sub-inspection record also.
I've tried relating tblLineStop to the other tables directly several different ways and then playing with the forms/reports to see if I can get where I want but I'm just getting frustrated.
Ultimately I would like to have a row somewhere in some table that records FKs for the InspectionEvent_PK, a sub-inspection FK(e.g., InspectMill_FK), and LineStop_PK (or FK depending on design) - - - - but I cannot figure out how to make it work.
Thanks for any and all thoughts and insights!
Tim