The link follows the primary key/foreign key relationship of the tables. As
an example. If you have an orders database:
tblCustomers
---------------
CustomerID (PK)
CustomerName
etc....
tblOrderHeader
-----------------
OrderID (PK)
CustomerID (FK)
DueDate
etc...
tblOrderDetail
---------------
DetailID (PK)
OrderID (FK)
ProductName
Price
Quantity
etc...
If the main form is for Customers, the subform is for CustoermOrders and the
sub-sub form is for customer order details then the links would be:
CustomerID from tblCustomer to tblOrderHeader
OrderID from tblOrderHeader to tblOrderDetail
In your case I would say that the link would merely be ProductID.
:
I can't seem to get my Subform to Sync with my Sub-Subform. The first
is an input form as is the second. I'm using this on the Links fields.
Child Link Product ID
Master Link [Product ID].Forms![Mods Detail]
Thanks for any help.
DS