One form, two tables...

A

Andy

Is there anyway to have a form that once data is entered, writes the date out
to two different tables. i.e. one section of the form will dump data into
table A and the other section will dump data into Table B.

Thanks
 
R

Rick B

Sure. Just include both tables in the query upon which your form is based.
Then pull the various fields from each table onto your form.

We'd need to know a bit more about your data structure and what you are
trying to accomplish to give you a more detailed answer.

If you have a one-to-many relationship, the answer is a bit more complex,
but still very easy to do.
 
Top