Copying data from other field to this field

rosari

Registered User.
Local time
Today, 11:47
Joined
Oct 11, 2007
Messages
10
Hi im new to msaccess so bear with me plz;
is there any way to copy data from the first column ie say the primary key which is a autonumber to the next column because i cant seem to have two autonumbers soi was wondering if it the next column would update as a new record is created

say coulmn 1 is ID column 2 is NameID
i want the autonumber generated in iD to appear in NameID
 
why have two columns with the same data?
 
its alrite don worry i worked it out i got rid of the second column and changed the data
 

Users who are viewing this thread

Back
Top Bottom