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
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