Data entry One Record Multiple tables

[Zydeceltico]

Hi All -

Time for my newbie question of the day.

I have frmInspection used to do QC inspections of various products. Data from frmInspection is recorded in tblInspections.

On frmInspection are a series of combo boxes that record "Yes" or "No" responses regarding a variety of potential production issues.

On frmInspection, when the user selects yes from any given combo box a popup form (frmIssueDetails) opens where the user can add details about the production issue they are observing.

Currently I am recording those details back into tblInspections but I think this is not going to be sustainable due to bloat mostly and the fact that only a small percentage of inspections result in the need to add an issue detail. I don't want a mountain of empty data fields in tblInspections. It seems like better design to have a separate table to record issue details.

I would like to have another table (tblQCIssues) where the data from frmIssueDetails is stored.

My noob question is how do I link the original inspection recorded from frmInspection and stored in tblInspections to the details stored in tblQCIssues? I can relate the tables via PK and FK obviously but I don't really get how, in the event of a need to record IssueDetails, that Access "knows" that "OK - the user is doing an inspection and recording data into tblInspections - but - OH -OH - Wait! Now the user needs me to open frmIssueDetails and get some data AND store it in a different table AND relate this new record in tblQCIssues to a specific record in tblInspections.

(Actually - I do know how to call the popup form - it's the rest of it I don't comprehend).



Can someone please refer me to a really clear tutorial?

lol

THANKS!

Tim

 

[June7]

Use a subform. Otherwise you will need code (macro or VBA) to pass ID to the popup form. One way to do that in VBA is with OpenArgs. Can get rather complicated and tricky. Better to use subform and let Access do that heavy lifting.