We are using SalesLogix LAN v7.2.1 with a table, myTableA, that has a field "Division". I want to be able to load the distinct values in the "Division" field in myTableA in a combobox (cmbDivision). Any idea how I can do this?
I could always hard code it:
etc. but I would always need to update the code whenever a new division was added to the table.
You can Query the DB:
'Assumption: adCon = ADODB.Connection object and adRec = ADODB.Recordset object. adCon has already been initialized and opened
Set adRec = adCon.Execute("select distinct division from TABLE")
Do While not adRec.EOF
cmdDivision.Items.add(adRec(0).Value & "")