Can I load Distinct values into my Division field via a Saleslogix table?

Question:

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:

cmbDivision.Items.Add(“Retail”)

cmbDivision.Items.Add(“Government”)

etc. but I would always need to update the code whenever a new division was added to the table.

Answer:

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 & “”)

 adRec.MoveNext

Loop

 

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) news and product updates!

You have Successfully Subscribed!