Hi All,
I have checked other postings, but I am having issues with text auto complete.
As I enter the payee name on a cheque transaction, it would be nice to prompt the user to use a previously entered name.
I have changed the field type to text auto complete and provided a select statement to a file of old payee names.
However, if I enter a new name in the payee field, I want to use that name AND save it to the payee name database.
I use the statement below in the validate event.
$sql = “INSERT IGNORE INTO payees SET pa_payee = ‘{tr_payee}’”;
sc_exec_sql($sql);
However, as the name is not in the payee data file, the program clears the tr_payee field after I click on the add button, and of course the insert fails as the pa_payee field is also blank, and the {tr_payee} field does not repopulate with what I typed in after the validation.
Any I missing some setting or other, or is it impossible to use that feature like a true combo box, and it will only accept what is in the select list.
Thanks
Tony