automatic ID generation

[madrav72]

Hi

I have a column which is made up of two parts from the table as follows...

function area .... FINANCE

ID number ... 001, 002, 003 etc

combined together this will make my ID column which should look somehting likie this : FINANCE 001, MARKETING 002 etc

BUT

the problem is that now i need to import some existing data into the tables and it appears as though the existing data has repeating numbers for different function areas

e.g.

FINANCE 001
FINANCE 002
MARKETING 001
MARKETING 002

how would i get this imported into my current table structure?

 

[madrav72]

can someone at least confirm whether the resolution lies in changing the table structure?

 

[locomotion]

you are going to have to be a little more specific

 

[madrav72]

ok well to clarify the problem

a column in a query combines the contents of both the Function and number to make up the FINANCE 001 etc


so for example the table contains 2 coluimns

Function ID
--------- --------
FINANCE 001
MARKETING 002
etc
etc

the numbered column is on autonumber and thus all the numbers here are unique

now the problem is that i need to import some data with various bits having the same number repeated e.g. HR 001 etc which causes a clash with other numbers in the ID column. therefore the question is can i import the repeated numbers into a table which is currently on autonumber?

 

[ScottGem]

No. The question is whether the ID number is being used to link to records in another table. If not, then there should be no problem in having a new autonumber generated. If there are related records, then you will need to add a temp field called OldNumber and fill that with the OldID. Then update the related records to the new ID.