How do I enter data in multiple-table form?

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

Guest

I have been unable to enter data in a form which draws fields from more than
one table. Fomrs drawn on 1 table allow data entry, others do not, even if
data entry box in form properties is set to yes.
Tables are linked. The utility of the form for convenient data entry is
drastically reduced by this problem, so I assume I'm missing something here.
No direct help on the on-line MS help site.
 
Does the form have a query as a data source? If so, try
entering data directly into the query. If the tables are
not set up properly, you won't be able to do so. You then
can rearrange the tables and try again. The problem is
usually one where you have a one-to-many table setup but
you are trying to enter data into a "many" field without
first referencing the "one" field.

Hope This helps
 
i do concur with aday.
the form wizard asks you how you would like the tables to be
displayed,either an open subform or subform on pressing the command button.
but if you the fields from "many" side table first,it assumes you do not
want to add data

prafull
 
Back
Top