To make things easy for me I have started using a field called "keyfield" in all my tables and populating it with dtoc(datetime())+sys(2015) which is for all but the most extreme cases assures me of a unique id with the added benefit of knowing when it was added.

>Mandy, IDs are like Texas Rangers & riots: One record, one ID. The ID field should be used JUST to identify a record, and should be your primary key.
>
>Barbara
>
>>Dave,
>>
>>I think you're right that your unique codeno method would work a lot better than my current "logic".
>>
>>When generating new id numbers, do you just use the next available number, i.e. if you have codeno's from 00001-00686 would you just make the next codeno 00687 regardless of the codetype? Then would my codetype be solely used for filtering a group of codes for a particular dropdown list (i.e. just my printer list)?
>>
>>Thanks!
>>Mandy