2 subforms in one form going to one table

[ryan.fitzpatrick3]

I have a form that is frmsupplier in this form, I have two subforms
subformingredients and subformpackaging. In these two subforms a user
would input items of that supplier, but one form the
subformingredients would have only ingredients and the packaging only
packaging. It would look like this

supplierID (autonum)
supplierNumber 132456 <-textbox
supplierName Mother's Cookies <---textbox

(this is an example)

subformingredients

1. flour
2. sugar
3. oil

subformpackaging

1. label
2. lid
3. plastic container

(there could be infinite number of items for each fyi)

I would like, if it's possible for to have both of the entries go into
one table linked to the supplierID.

The table for the subformingredients goes into stblcomponent. I have
the master/child links set to supplierID.

The issue I have is when I have both subforms in there and link them
the same way to the supplierID both tables reflect the same data. How
do I get the data to reflect what I want and go into a table without
giving me the same information in the both tables? Do I make another
table for the packaging and make it seperate? Thanks for your help.

Ryan

 

[nomadk]

Ryan,

I think you answered your own question: you want separate tables for
ingredients and packaging. Add fields for Supplier ID to both tables and use
it as Master-Child fields to link the subforms to your form.