J
JKarchner
I was wondering if it was possible to set up a subform so that when data is
entered in it, the data will be entered into two separate tables. I know
that this may sound like data repitition, but it shouldnt be. I have a
subform that is linked to a table with a MANY-to-MANY relationship. This
table is called ProductSupplyParts and it stores the Product_ID,
SupplyPart_ID, and Supplier_ID that are foreign keys from the Products table,
theSupplyParts table, and the Suppliers table, respectively. Now because
only SupplyParts in Category_A have like 5 or 6 extra attributes that do not
apply to any of the other SupplyPart,s i created another linking table table
that uses only the Product_ID and the SupplyPart_ID and called it
ProductsCategoryA. Is there anyway that when i enter data into the subform
that the data will be entered into both tables?
entered in it, the data will be entered into two separate tables. I know
that this may sound like data repitition, but it shouldnt be. I have a
subform that is linked to a table with a MANY-to-MANY relationship. This
table is called ProductSupplyParts and it stores the Product_ID,
SupplyPart_ID, and Supplier_ID that are foreign keys from the Products table,
theSupplyParts table, and the Suppliers table, respectively. Now because
only SupplyParts in Category_A have like 5 or 6 extra attributes that do not
apply to any of the other SupplyPart,s i created another linking table table
that uses only the Product_ID and the SupplyPart_ID and called it
ProductsCategoryA. Is there anyway that when i enter data into the subform
that the data will be entered into both tables?