Can I have a sub-subform related to subform which is related to the main form?

[lawdy]

I have 3 tables relating together as follows:

.................................................. ........................................PeopleNote s table
.................................................P eople table ......................ID
Companies table ........................ContactNo-----one to many----ContactNo
CustomerNo -------one to many-----CustomerNo......................... Date
Phone ........................................FirstName. ......................... GeneralNotes
CompanyName ............................LastName
Address .....................................Title
City ...........................................Email
State
Zip



Please disregard the dots, it is the only way I could line it up.
I have tried and tried but cannot put the 3 on one form linked together. I see a lot of examples where a form and a subform are together. I have found nothing where one form is linked to another, then the second form is linked to a third. Thanks in advance.

[June7]

Companies is the main form, People is subform, PeopleNotes is subsubform?

That is nothing special. Just that only innermost level can be in Continuous or Datasheet view, all others must be Single.

If you want two side-by-side subforms linked, review http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

[lawdy]

I was afraid of that. Thank you very much.

[June7]

That's why some resort to the side-by-side linking.