richard1458
Instructor
I have a maketable query that exports data to another database. It currently preserves the AutoNumber field form the orginal table. I don't want to do this - I want the field in the destination table to be an ordinary Number field, since only the source database is responsible for generating the records.
Should I:
1. Create an expression in the MakeTable query that simply returns the current value of each AutoNumber field OR
2. Try and write some code so that when opening the target database, the AutoNumber fields are automatically redefined as Number fields (and if so, what is the code and where would I put it to ensure that it runs every time I open the database).
Many thanks [sig][/sig]
Should I:
1. Create an expression in the MakeTable query that simply returns the current value of each AutoNumber field OR
2. Try and write some code so that when opening the target database, the AutoNumber fields are automatically redefined as Number fields (and if so, what is the code and where would I put it to ensure that it runs every time I open the database).
Many thanks [sig][/sig]