Data Entry in multiple tables in 1 form.

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

Guest

I have a question. I'm a new user and was wondering if it is possible to
enter data for multiple tables using 1 form. I tried using a main form for
the my client list and a subform for the clients who are employees. but it
didnt seem to work. Does anyone have any suggestions??
 
tflett said:
I have a question. I'm a new user and was wondering if it is
possible to enter data for multiple tables using 1 form. I tried
using a main form for the my client list and a subform for the
clients who are employees. but it didnt seem to work. Does anyone
have any suggestions??
Click to expand...

It is possible and often desirable, but my guess is you may have a poor
table design.

What tables are involved and what data is stored in them and how are
they related.

If you have a table design problem, you will want to fix that first.
 
I have a question. I'm a new user and was wondering if it is possible to
enter data for multiple tables using 1 form. I tried using a main form for
the my client list and a subform for the clients who are employees. but it
didnt seem to work. Does anyone have any suggestions??
Click to expand...

Not without knowing more about the structure and relationships of your tables,
no. Multiple tables are usually handled by using a Form for the "one" side of
a one-to-many relationship, and a Subform for the "many". It sounds like
you're trying to use a form and a subform for different subsets of the same
table, which doesn't fit this paradigm. Might it be possible to use two
parallel subforms, side by side on an unbound form? Or could you just use one
form?

John W. Vinson [MVP]
 
Back
Top