Announcement

Collapse
No announcement yet.

Text auto-complete - still an issue for me

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Text auto-complete - still an issue for me

    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

  • #2
    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.
    It's just not possible with a auto complete field.

    jsb

    Comment


    • #3
      After hours of testing just about everything I am capable of, I also have come to that conclusion. I have lodged a suggestion post, as it seems ridiculous that you cannot do this.

      Comment

      Working...
      X