Single Post to multiple tables

[Guest]

Greetings,
Is there a simple way to have users enter data through a single web page
and have the data post to multiple tables? How about some of the same data
to the various tables?

Regards,
James A. Hensley
Perpetually Puzzled

 

[Rick B]

If the form is based on a query with multiple tables, then the data will go
to the appropriate tables. In most cases these would need to all be
one-to-one relationships in order for this to work. The query must be
updateable.

For one-to-many situations, you would need to use subforms.