> Thanks but I guess it wasn't to clear what I need. Say I have a field

named OBSTRUCTIONS and the valid entries are "TREES" "TOWER" "BUILDING"
"NONE" and "OTHER". I can set constraints to limit input to this field to
these values OK but I also need to have a drop down list for the user to
choose from. Otherwise how would he know what to enter. Also I don't want
the user to type the entry, just pick it from a list. This is pretty
important to my app and seems like something the a db system would support.

Right. Now I understand. And how do you expect a generic database engine to
populate a Windows combobox then?

So, the answer would be: you need to do that yourself.

Just code the entries in the combobox.

Like I said in my earlier message Firebird does exactly what I need with
the drop down list of available domains. Thanks again. Bob Ritter

>

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com