Sub-Sub Forms Sync

[DS]

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

 

[rowiga]

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.

 

[DS]

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

Thats the problem, the link is not a one to many like it should be.
Perhaps my tables need to be readjusted.
Thanks
DS

 

[Keith]

I know this sounds weird but put a text box on the main form and under
properities
Control source put
=[Name of 1stsubform].[Form]![Linking Field Name for the linking field
between the two subforms]
Example: =[CustomerOrderID].[Form]![OrderID]

Also set your master and Child link to OrderID

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

Thats the problem, the link is not a one to many like it should be.
Perhaps my tables need to be readjusted.
Thanks
DS