Subform within a Subform

[Guest]

Newbie access user - so please be gentle ;-)
In a form I have a particular subform that has another subform within it.
Example I have information about a project - (Main Form) that has a series
of documents (subform) that will have their information that have several
people (purpose of the subform within a subform) assigned to do something to
the documents.
Now I can select and store the information about several documents on a
specific project, but I loose it when I try to associate the resources
assigned to the documents within that project...
I hope I've explained this well enough - bottom line is 1 project can have
many documents which can have many resources - so how do I build a form that
allows me to update and track this information by project?

 

[Guest]

You spoke much on forms and subforms but narry a word about tables and
fields. Or did you forget that is where all data for the forms is stored?
Tell us about your table structure, field names, datatypes and relationship
to other tables.
It would seem that you need a table for projects and relate it one-to-many
to your documents table. The same for documents table related it one-to-many
to your resources table.

 

[Guest]

Ah good point - and therein (I hope) lies my problem:
when creating the Project Document table I created a key field (auto number)
and then created several "lookup" fields. I created these fields by using
the "lookup Wizard" so it would grab information from existing tables.
In the Relationship Diagram the lines are connected by I really don't know
how to change the relationships to make them work correctly - lack of
database knowledge.
Currently the relationship is a one to many.
So...
I have a table that has values in it populated from a lookup from other
tables:
ProjectID (key field in Project table) is related to ProjectName (field in
ProjectDocument table)
ResourceID (key field in REsources table) is related to ResourceName on the
ProjectDocument table
DocumentID (key field in Document table) is related to DocumentName on the
ProjectDocument table.

Clicking on the relationship line brings up the pop-up "Edit Relationships"
window and for all of them, the "Table/Query" is on the left side with the
"source" table and field selected and the right side has the ProjectDocument
table listed with the corresponding field in that table (the one I created
using the lookup wizard).

All 3 are like this and all are one to many - "Enforce Referential
Integrity" is NOT checked and on the Join Type "Only include rows where the
joined field from both tables are equal" is selected.

I hope that better clarifies the picture - thanks!

 

[Guest]

Give me your table names, field names, and their datatypes.
Post a sample of data from each table.