how to pull a record to a form and save it to a diffrent table

L

Lorraine

hi,
I want to pull data from more then one field ( as it seems with a combo
box with multiple fields listed in a row ) and have it save these fields to a
diffrent table. What I'm trying to do is take a Whole record and save that
record to a new table.

Thanks
L
 
K

Klatuu

Why?
It is not necessary to store redundant data. It is, in fact, a database
design fault. If you can describe your objective, perhaps we could offer an
alternative solution.

But, in any case, unless you need to see the original record first, there is
no need for a form.
 
T

tina

it's unusual to store identical records in two tables, or to move records
from one table to another. can you tell us what you're trying to accomplish
by doing this? perhaps someone can suggest a better solution.

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to pull a record to a form and save it to another table 1
how to pull a record to a form and save to another table 1
How to pull a record to a form and saving it to another table. 6
How can I pull a record to a form and save to another table. 1
How to pull data from one table and save it to another 12
Table Splitting Questions 7
want to save the record number in a field 2
Access Automatically Send a notification email once a record is added 0

Top