Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created 7 tables with one-many relationship, Now that i want to create
forms and subforms, how do i go about it? Do i have to create form for each
form and do subforms for them? Please advice & help.

Thanks.
 
I have created 7 tables with one-many relationship, Now that i want to create
forms and subforms, how do i go about it? Do i have to create form for each
form and do subforms for them? Please advice & help.

Thanks.
Click to expand...

Depends. How are your relationships structured? A "starfish" with one
master table and six dependent tables? A "ladder" with each table
related one-to-many to the next table in line? Something else (much
more common)?

Typically you would create a Form based on the "one" side table in a
relationship, and then use either the subform wizard to create a
subform; or create your own subform based on one of the "many" side
tables and drag it onto the mainform in design view.


John W. Vinson[MVP]
 
Back
Top