Primary Key auto numbers

[Jenny1]

I have used priamry keys in my tables and these are set to auto numbers on the advise of fellow forumites.

One question if at the end of every year I need to upload batches of data to my tables, this would mean I would need to go through each record and manually enter the foreign keys in the linked table.

Surely Access has a better way of dealing with this issue?

 

[<DC>Paul]

I have used priamry keys in my tables and these are set to auto numbers on the advise of fellow forumites.

One question if at the end of every year I need to upload batches of data to my tables, this would mean I would need to go through each record and manually enter the foreign keys in the linked table.

Surely Access has a better way of dealing with this issue?

there must be away to turn it off

 

[Dennisk]

if you are loading one-to-many records both on the one and many side then do it using VBA.

How would Access know which record and the many side is associated with the one side record when you are importing?

 

[Jenny1]

why not just copy and paste the details from one spreadsheet to the access tables.

 

[Dennisk]

have you tried it?

 

[gemma-the-husky]

not sure what you are doing, but - when you load the data into your file the autonumbers will be allocated automatically.

if the new data is linked in some way to another table, then presmably there is some matching index other than the autonumber field that will link the tables together., or you using the new data to generate data. either way you should be able to find a way to create a series of queries that will manage the links for you.

i do things like this all the time, and i should imagine a lot of other users do - you don't want to change things by hand if you can avoid it.