update a table which automatically assigns a new reference number for

[donnie051280]

update a table which automatically assigns a new reference number for each individual record. i assign 6 values to the table and i want the 7th value to be the primary key which has a different reference number for each new record

 

[EBGreen]

If I understand the question, then in the table design, all you need to do is create the six fields that you will be assigning in your update then create a seventh field and set its type to autonumber.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]