Conditional data input to secondary table

[Zydeceltico]

Hi All,

I work at a manufacturing plant in QC.

We have been developing a database to record inspections on 1) the rolling mills and 2) the assembly lines. These are two different tables and two different inspection forms - both general in nature that captures 88% of all required data. These are tblMillInspection and tblWeldAssembly respectively.

On frmMillInspect is a cbo (cboPartNumber) that is used to select which part is being produced at a given mill.

We have one product that requires inspection of several characteristics that are completely unique to that part. Those characteristics are not currently being recorded and are not fields in tblMillInspection.

I am envisioning that when this product (ENVF-18) is selected in cboPartNumber on frmMillInspect a secondary popup inspection form (frmENVFSpecific) automatically presents itself for the user to record product specific data in. This data would not be written to tblMillInspect. Instead it would be recorded in another table (tblENVFInspect) and hopefully linked to the "parent" inspection record in tblMillInspect.

Is this possible? Is there a better design? If it is possible how do I do it? I am not a VBA wiz so please be detailed.

Thanks in advance,

Tim

 

[Ranman256]

it seems you may need 5 tables:

tMachines,
tParts,
tMachParts (what parts are made on what machine)
tMachInspect, (inspections for a machine)
tPartInspect (inspections for a part)

 

[Zydeceltico]

it seems you may need 5 tables:

tMachines,
tParts,
tMachParts (what parts are made on what machine)
tMachInspect, (inspections for a machine)
tPartInspect (inspections for a part)

I do have tblWorkstation which filters parts to cboPartNumber as parts are made on very specific and unique mills. No part is made on more than one mill - and can never be. However, on any given mill, multiple parts can be produced.

So in fact I have:
tblWorkstation
tblPartNumber
tblMillInspect

....but I think I see what you're getting at. I Need to take it further by creating mill inspections for each mill uniquely - and subsequently for each part made on a given mill. Seems like a lot of tables and forms - but I get it.