I found an example (purchase.pdf) that connected to an Access Database and through a drop down populated fields. But the problem that i have is that as soon as i try to change the search field from ID to say products, the code does not work. What I am looking to do is have a user input data into a Text Field and on exit, search a database based on that data and populate fields. say... "Select * from customers Where product = " this.rawValue;
This is the working code from the exaple, but, it will not work when I change ID to Products.
if (Len(Ltrim(Rtrim(SelectField.rawValue))) > 0) then
$sourceSet.DataConnection2.#command.query.commandType = "text"
$sourceSet.DataConnection2.#command.query.select.nodes.item(0).value = Concat("Select * from customers Where ID = ", Ltrim(Rtrim(SelectField.rawValue)) ,"")
$sourceSet.DataConnection2.open()
endif