Nested subforms form

[Guest]

Hi

I am creating a database that will assist ppl in creating project plans, I
want to be able to create a form that will look like:

http://www-project.slac.stanford.ed... Project Plan Draft, 11-14-01/tracking/79.htm

I have tables for each lvl that are connected so i can more or less create
the form. The problem i have is the way I do it is to have lots of nested
subforms so the top lvl (Dark blue, see diagram) is the top form and the
bottom lvl(white) is the most nested, this work but the problem is the middle
lvl(green) can't be a continuous form so i can show the blue then one green
then all whites but u have to press next record to get the next green, i
wanted it all on one continous form so it looked exactly like that. Is there
any other way to show information from another table that is linked to the
higher table other than a subform so that both can be continous. I hope i
have explained my problem well enough.

I would really appreciate any help as this would be a marvolous form and
help me greatly if i could get it to look like the pic.

Cheers

Danny

 

[Guest]

Danny:

The way to correlate two or more continuous subforms is to have them all as
subforms of the same parent form and put a hidden text box in the parent form
which references the key of the first subform. This control is then
referenced as the LinkChildFields property of the second subform control.

To take a simple example, say you have a continuous subform of Orders in a
parent Customers form in single form view. The subform is linked in the
normal way on CustomerID. In the parent form add a hidden text box
txtOrderID with a ControlSource of:

=sfrOrders.Form!OrderID

where sfrOrders is the name of the subform control housing the orders
subform. You can now add an Order Details subform to the parent Customers
form with a LinkMasterFields property of txtOrderID and a LinKChildFields
property of OrderID, the former referencing the hidden control on the parent
form, the latter referencing the foreign key OrderID field in the
OrderDetails table.

As you navigate form row to row in the orders subform the rows in the order
details subform will change to show the order lines from the order selected
in the first subform.

Ken Sheridan
Stafford, England