OK guys, I have a table in access like this
ClientID - Autonumber
ClientName - Text
Also I have a table like this
SportID - Autonumber
SportName - Text
And lastly, a table like this
ClientID - Number
SportID - Number
OK, I shouldnt have to explain that any more because its just a simple 2 tables design with a linking table.... anyways my problem is that I have a separate table in a different database like this
ClientID - Number
SportID - Number
ClientName - Text
SportName - Text
Now the data in this database I need to move over into the first database, the problem I have is that when I try to copy and paste append I cannot paste the ClientID because it upsets the autonumber - I can paste the data if I change the datatype from autonumber to number, but then it wont allow me to change the datatype back to autonumber after I have populated the tables.
In the second database the ClientID and the SportID are the same value and are basically the first record's value is 5000 and the last value is 6875.
I do appologies if the description is a little sketchy but I have had several pints and several whiskey's and everything is starting to look a little blurry.
Would be greatful if anyone has any ideas.
Oh yeah BTW - this isnt the actual table design, but if you answer the question then I will be able to implement it into my rather larger proper design. Cheers in advanced.
Reply With Quote