"bicyclops" wrote in message
...
Samples:
PartPrefixID Part Type (Prefix) Prefix Description
1 001 CAD
2 400 Assembly
3 500 High-Level Assembly
4 998 Unknown
5 011 IC, Through Hole, Programmed
6 260 Stencil
7 350 Misc. Assembly
8 410 Flash Card Kit
9 411 EPROM Kit
10 999 Generics

The data types are Autonumber, Text & Text


No obvious explanation is jumping out at me. If you'd like to send me a
cut-down copy of your database, containing only the elements necessary to
demonstrate the problem, compacted and then zipped to less than 1MB in size
(preferably much smaller) -- I'll have a look at it, time permitting. You
can send it to the address derived by removing NO SPAM and ".invalid" from
the reply address of this message. If that address isn't visible to you,
you can get my address from my web site, which is listed in my sig. Do
*not* post my real address in the newsgroup -- I don't want to be buried in
spam and viruses.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)