Subform

[Microsoft]

Access 2007

I have a form (TopLevel) that contains a subform(HeaderLevel) - the subform
is header information for another form(ItemLevel).

Data construction
ToplevelTable (One to Many relationship with HeaderLevelTable)
HeaderLevelTable (One to Many relationship with ItemLevelTable)
ItemLevelTable

I want to be able to open the TopLevel Form and enter records into the
subform(HeaderLevel) that relate to the TopLevelRecord.
I then want to be able to double click on the HeaderLevelRecord (in the
subform) and enter items into the ItemLevelTable that relate to the
HeaderLevelRecord

How can I do this?

I can get the subform (HeaderLevel) to only show existing records relating
to the TopLevel but cannot add new records

What do I need to do? is this possible or am I going about it in the wrong
way?

Thanks

A

 

[strive4peace]

"but cannot add new records"

make sure that each form/subform is based on just one table. Read this
and pay close attention to the the mainform/subform section:

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace


Warm Regards,
Crystal


*
have an awesome day
*