right. i think that will solve most of your problems with this...
>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
>
>>i usually use only one unique id number table for all my lookup tables (every code has its own distinct number and may or may not be sequential). i think you'd need to store the codetype AND codeno the way you're numbering them now. if (for your example) positions were 1 - 3, printers 4 - 6, etc. you wouldn't need to know the codetype when looking up this info...
>>
>>>Barbara,
>>>
>>>Boy have I been falling a lot lately ;)! (it's tough teaching yourself to ride that bike without training wheels or a parent to hold you til you're steady!)
>>>