This sample illustrates a number of ways to simulate your own Autonumber primary key.

Form1 illustrates how to use the DMax function to simulate the action of the Autonumber field.

Form2 does much the same as the Products form, but allows for multi-user collisions.