one access table to automatically enter data into another

[robertchad]

I need help. I am trying to create a database that when I click on an option
box that data in several fields of a table are automatically entered into
another table. I have tried looking at several books but haven't had any
help. Thanks for your help.

 

[Tim Ferguson]

several fields of a table are automatically entered into
another table.

Bad bad bad bad bad bad bad bad....

I have tried looking at several books but haven't had any
help.

No you won't, because it's a bad thing to do. Do some reading around
relational theory and database design -- the clue is that every piece of
information is stored exactly once, and only _ever_ referenced by table
name, column name, and PK value.

Hope that helps


Tim F