saving to multiple tables

[DanielS]

Is it possible to use one form to save data in multiple
tables? I am creating forms via the wizard and it only
allows selecting one table. Any thoughts?

 

[Ted Allen]

Hi Daniel,

I believe that the wizard allows you to select a table,
then select the fields from that table that you want on
the form, then select another table, select fields from
that table, etc. After that it will ask you how you want
to join the tables.

Another approach is to design a query first that has all
of the fields from the various tables that you want to
have in your form. Then, select the query and all of its
fields as the source for your form.

HTH, Ted Allen

 

[Guest]

Excellent, Ted. Thanks so much.