I'm having trouble nesting more than one subform. Here's my scenerio...
I have 4 tables:
Table1 = Orders (Maid order table)
Table2 = Material (Material portion of the Main order)
Table3 = MaterialDetails (Materials details)
Table4 = Products (Actual products)
Here's my relationship:
"Orders" (one) <- (many) "Material" (one) <- (many) "MaterialsDetail" (many) <- (one) "Products"
I've created a main form called "Orders" that has a subform called "Material". "Material" has a subform called "MaterialDetails". "MaterialDetails" is a combination of "MaterialDetail" and "Products" table items.
So basically I have a form, nested in a form, nested in a form.
When I use the "Main" form to create an order, it autonumbers the PK for the "Main" table but it doesn't autonumber the PK for the "Materials" table when I select a "Product" within the "MaterialDetails" subform.
As a test I created a new field in the "Materials" table called "Stuff" and inserted it into my "Materials" subform. Now, if I start a new order, then go directly to the "Stuff" field and enter any data, then select a product from within the "MaterialDetails" subform I get a new autonumber for the "Materials" table.
Anyone know of a way to get the "Materials" form to autonumber itself once a new "Order" or "MaterialsDetail" item is created?
I have 4 tables:
Table1 = Orders (Maid order table)
Table2 = Material (Material portion of the Main order)
Table3 = MaterialDetails (Materials details)
Table4 = Products (Actual products)
Here's my relationship:
"Orders" (one) <- (many) "Material" (one) <- (many) "MaterialsDetail" (many) <- (one) "Products"
I've created a main form called "Orders" that has a subform called "Material". "Material" has a subform called "MaterialDetails". "MaterialDetails" is a combination of "MaterialDetail" and "Products" table items.
So basically I have a form, nested in a form, nested in a form.
When I use the "Main" form to create an order, it autonumbers the PK for the "Main" table but it doesn't autonumber the PK for the "Materials" table when I select a "Product" within the "MaterialDetails" subform.
As a test I created a new field in the "Materials" table called "Stuff" and inserted it into my "Materials" subform. Now, if I start a new order, then go directly to the "Stuff" field and enter any data, then select a product from within the "MaterialDetails" subform I get a new autonumber for the "Materials" table.
Anyone know of a way to get the "Materials" form to autonumber itself once a new "Order" or "MaterialsDetail" item is created?