Add data into a table

[Becker]

Is it possible to add the values from text boxes on a form into a table other than the one the form is bound to? For example: I have a text box "productionid" on form "data" which is bound to the query "info". When a button is clicked I would like the user entered value in the text box "productionid" to be saved as a new record in the table "labor". I hope that makes sense what I am thinking.

[NeoPa]

Yes. It can be done, but why would you want to? Why not have a bound form for the table instead?

[Becker]

The form is already bound to a query that doesn't have the table of interest in it. There are multiple records on the one table for each record in the query so it was messing up my query having them together.

[zmbd]

Respectfully, this issue indicates a serious problem with the over-all database design[*]> Database Normalization and Table Structures.

[NeoPa]

You say "The form" Becker, but I was saying a form. Maintaining the data of two separate tables from a single form is dangerous and only for the very experienced - who would tend to avoid it anyway unless there were a very specific reason why it might make sense in a particular set of circumstances.