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