form/sub forms

  • Thread starter Thread starter Patti
  • Start date Start date
P

Patti

I have two questions:

1) When I create a new form using the wizard and select all the fields in
one table, then select another table from the drop-down & again select all
the fields, the wizard does not give me the option to create a form/subform.
The primary key is the same in both tables & I have defined a relationship
in the Relationships window. Any idea what would cause this?

2) What problems can I expect when I include fields from separate tables on
a single form? I realize the issues with the one-to-many concept, but
wondering if there are any other data integrity considerations.

TIA,

Patti
 
1) The option to create a subform should show if you
select the ONE-to table first and then the to-MANY table
of the relationship. This will make the to-MANY table the
subform.
The wizard will not consider a subform if you start by
the MANY side of the relationship.

2)It seems to me that if you are feeling the need of
having severall tables in one form, probably you just
need one table in the first place ;-)
 
Hi Luis,

Are there any other setting to check? I am selecting the table with the one
side first, then the table with the many side. Not only is it not giving
the subform option, it is including only the fields from the one-side table
on the form.

I definitely need more than one table or my database would not be
normalized.

Thanks
 
Back
Top