I'm trying to populate a droplist with two values from a DB table. One is the index and the other is name. When a name is selected I need the index value to be saved to the main table. I understand that in order to do this I need to use a Select statement with the dbEditDropFlds property. I'm having problems with the syntax. How to I construct this?

HELP!!


oDB.dbEditDropFlds = "Fld=[fldDeptFKey] ConnStr[] UserData=[] DropCrit=[Select fldPkey, fldDeptName From tblDepartments] AddNull=[] NoBlank=[] DSize=[]"