case selection custom data types

[Guest]

I don't know how to create custom data types in access 2000, I need to write
several case selection data types to simplify an inventory database, where
users can select one data type from a pull down list.
I used to do it with a little SQL when i used Paradox but Access seems to
oversimplify things so much I can't get many advanced DB capabilities to work
and the help file is useless. Can somebody please stop me losing my hair over
this one?

 

[Alex Dybenko]

There is no custom data types in Access.

As i understand you - go to table design, in field properties go to lookup
tab and set display control to Combobox