Data Entry in multiple tables in 1 form.

T

tflett

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??
 
J

John W. Vinson

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]
 
Top