Showing "sub" expandable related tables in form (1 Viewer)

[brickelldb]

Is this possible to have available in a Form???? To show in a Form tables with the related tables below to be able to insert records in this view? I have been searching high and low and maybe im not searching proper terminology? Is this even possible in access?

 

[Dennisk]

you require a main form and subform. Although it will not look like the expanded tables it will work the same.

Create two forms and drag the subform onto the mainform. A wizard may run to set up the primary and foreign keys, but I would check it yourself.

 

[brickelldb]

Yeah, that's what I started doing because I became discouraged. It's just that the expanded related tables is such a cool interface (in my opinion anyways).

Hey, thanks for the response!