I have a main form that contains 3 subforms. The subforms capture Material Usage data for the associated machine and the data is stored in tbl_MaterialUsage.
ProdID (FK - Parent Field to subforms)
The attached screenshot shows the subforms...Each line is a subform that corresponds to a specific machine. I need a way of storing that machine ID, but I do not want to store records unless the user enters information in the Material and Usage fields on that subform. ProdID, MaterialUsageID, and MachineID are hidden in the subform.
Also, if you have any other methods or design suggestions, I would love to hear them as I suspect my use of multiple subforms may not be the most effective.