Relationships: One FORM to many TABLES?

[DianaS]

Hello,

I have created a form for data-entry, and I would like it to send data to
multiple tables. For example, if Table A has Fields 1 through 5, and Table B
has Fields 6 through 10, I would like the form to contain Fields 1 through
10. When data is entered into the form, the respective info is sent to
Tables A and B. Is this possible?

Thanks,
Diana

 

[Rick B]

Yes. You would build a query with all the tables and fields you will be
updating and viewing in the form, then create a form based on that query.

Of course, the tables you mentioned would each need to have a common "key"
field such as customer number or employee number.