One form, two tables...

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

Guest

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
 
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.
 
Back
Top