Create ID

[theconfusedbear]

I have a table of around 100,000 records all with a unique contract ID. However there are several entries holding different information on each line but with the same contract number. How can I assign each contract number with its own ID for example contract number 12345 has 6 different entries in the system which i need to keep but i want to assign that contract number with its own ID so i can provide a better contract count instead of it appearing 6 times.

 

[Pat Hartman]

The items associated with a contract need to be placed in a separate table. Take a look at the Northwinds sample database. It is an example of a simple order entry application and is a good example of how to employ 1-many relationships. i.e. 1 customer can have many orders. 1 order can have many items.