Connecting tables.

The rowtag is a variant so it is very flexible. An example might be

rs = database.sqlselect(your sql)

listbox.addrow rs.field(“companyName”).stringvalue
listbox.cell(listbox.lastrow,1) = rs.field(“companyStreet”).stringvalue

listbox.rowtag(listbox.lastrow) = rs.field(“companyID”).Integervalue

Now say you have a row selected and you click a delete record button. Your sql may look like…

database.sqlexecute("Delete from companyTable Where companyID = " + listbox.rowtag(listbox.listindex).stringValue

or if you prefer

dim deleteID as integer = listbox.rowtag(listbox.listindex).integervalue

database.sqlexecute("Delete from companyTable Where companyID = " + str(deleteID)