Multiple nested forms

[skiing]

Hello !

Hopefully I can explain this request for help in an understanding
manner. I apologize, up front, if it is confusing.

I have 4 tables which I need to compile into one form. I can use a
query to pull all of the information together but I need to see the
information in the one-to-many view.

Basically I have somthing similar to the following:
( I have made these examples tables as simple as possible in an effort
to be as clear as possible)

Table: Table1
Field: Item no
Field: Detail

Table: Table2 -- related to Table1 ( one to many relationship) on
the field of Item No
Field: Item no
Field: Item no 1
Field: Detail 1

Table: Table3 -- related to Table2 ( one to many relationship) on
the field of Item No 1
Field: Item no 1
Field: Item no 2
Field: Detail 2

Table: Table4 -- related to Table3 ( one to many relationship) on
the field of Item No 2
Field: Item no 2
Field: Item no 3
Field: Detail 3

The form should show the main item from Table 1, then view all items
in Table 2 which relate, view all items in Table 3 which relate and
then Table 4. I can get the form to maintain the relationship link
with 1 form and 2 subforms - but I cannot get the 4th form to maintain
the relationship.

The data is something like this:
Table 1 = Reference Documents, their ID, title, etc...
Table 2 = Task "Headers" for task described with the reference
document ( like Replace Valves, Install Flow Elements)
Table 3 = Task details - buy new valves, remove old valves, etc...
( would be the relational items to Replace Valves
Table 4 = Would be components/devices to be replaces, drawing numbers
for the drawing details of the components, etc...

When I view the data - I need to see
a) The Reference Document and some other fields of that table
b) All the Task Headers associated with this document
c) When I click on a particular Task Header I need to see all the Task
Details associated with it.
d) Which in turn should display all the components/devices and drawing
information.

Thank you for any assistance you can offer.

 

[Lynn Trapp]

I have 4 tables which I need to compile into one form. I can use a
query to pull all of the information together but I need to see the
information in the one-to-many view.

The form should show the main item from Table 1, then view all items
in Table 2 which relate, view all items in Table 3 which relate and
then Table 4. I can get the form to maintain the relationship link
with 1 form and 2 subforms - but I cannot get the 4th form to maintain
the relationship.

You can have multiple levels of subforms but you can only have one
datasheet view form in the hierarchy. Thus, forms 1, 2, and 3 would
have to be in form view and form 4 could be in datasheet view.
Lynn Trapp
www.ltcomputerdesigns.com

 

[sgmaxmp11]

You can have multiple levels of subforms but you can only have one
datasheet view form in the hierarchy. Thus, forms 1, 2, and 3 would
have to be in form view and form 4 could be in datasheet view.
Lynn Trapp
www.ltcomputerdesigns.com