Nesting Subforms
MainForm with 4 Subforms (1-4)
Subforms are all in a tab control
Subform4 contains another subsubformA
Records of Subforms (1-4) are linked to Mainform by ProjectID
(Child-Masterfield….)
Its works great so far, but (the nested sub…)
Subform4 contains records of TasksID
subsubformA contains TrtmntID
Subform4 is linked to subsubformA by TaskID (Child-Masterfield….)
subsubformA contains TrtmntID only (no more ProjectID)
That makes TrtmntID show up on all ProjectID’s
What am I doing wrong?
I can auto# the TaskID, making it unique for every ProjectID and it works,
but its not really nesting….
Do I need to create a query containing both tables and adjust join properties?
|
|