Hi, Fred. Use an autonumber field in the table. For the part number, use an
expression like =([name]&"-"&[model]&"-"&[autoIDnumber]

-*--*--*--*--*--*--*--*-
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Com.Piersontech@Dreamboat
(Reverse it!)
Web: www.TheOfficeExperts.com
-*--*--*--*--*--*--*--*-
"Fred" wrote in message
...
Greetings,
I have a project where I have to assign a three-part ID
number to each new entry. The first two parts to
the "number" are typed in by the user. Access is to assign
the numeric part (e.g. 1,2,3...)
e.g. Fred - Ford - 1
Fred - Ford - 2
Fred - Toyota - 1
Freda - Ford - 1
etc.

Has anyone been able to do this?
Please help!