Copy field into a new table

  • Thread starter Thread starter Ian Rhodes
  • Start date Start date
I

Ian Rhodes

I want to be able to copy the contents of a record field in to a
different table as a new record using a command button. Help rquired
for newbie please
 
Ian

You want to copy data from a field in one table into a field in another
table? Unless you are describing putting a "foreign key" value into the
second table, based on a primary key in the first, you really don't want to
do this! Not with a relational database like Access.

And if you are talking about a foreign key, the easiest way to do this is to
use a main form/sub-form approach. The sub-form "inherits" the primary key
value from the table behind the main form, and treats it as a foreign key.

Good luck

Jeff Boyce
<Access MVP>
 
Ronald said:
In help, lookup Insert Into.

Ron
Click to expand...

NOt finding anything that matches what I want to do. Will set outin
more detail in a fresh post so people will understand exactly what I am
trying to acheive

Thanks Ronald & Jeff
 
Back
Top