composite key question

[revnice]

How do I make sure a customer number is permanently associated with a particular customer?

Right now, I have a customer ID column (four digit number) but if I delete a row all the numbers ripple up and everything is then wrongly assigned.

Example:
0001 Acme Pencils
0002 John's Sheet Metal
0003 Fred's Groceries



If I now delete 0002, I get

0001 Acme Pencils
0002 Fred's Groceries

From 0002 onwards all the customers have the wrong numbers assigned to them.

I think I need a composite key made from Number and Name but how do you make one? In the design view, I only see Primary Key...

Thanks - rev

[ajetrumpet]

composites are made of more than one primary. make one by pushing the primary key button in more than one field

[revnice]

Thanks!

(Am I correct in assuming that's the problem/and the fix?)