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


"Dirk Goldgar" wrote:

"bicyclops" wrote in message
...
Dirk - answers below.

Row Source:
SELECT TblPartPrefix.PartPrefixID, TblPartPrefix.PartPrefix,
TblPartPrefix.[Prefix Description] FROM TblPartPrefix ORDER BY
TblPartPrefix.PartPrefix;

Bound Column:1
Control Source: PartPrefixID
Default Value: blank
Column Count: 3
column Widths: 0";0.5";2"
Format: blank

Thanks for looking into it!

Could you give me a few sample rows from TblPartPrefix? There aren't any
rows with the same PartPrefixID, are there? What type of data are
PartPrefixID and [Prefix Description]?

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

(please reply to the newsgroup)