Dynamic Action based on Text Field with autocomplete to populate fields
I have a form based on a stored procedure. The first field is for the user to type in a name. It is displayed as Text Field with autocomplete. If the user types in a name that's already in the database, I'd like for the rest of the fields in the form to populate with the data for that name. Otherwise, they stay blank and the user inputs the data for all the fields.
I created a dynamic action that fires on change (also tried loses focus) of the first field. The action runs a query to get another column value based on the name field and set that value in this second field. However, it doesn't seem to be doing this. I can't tell if it's because it's not firing at all or it's not setting the value as I anticipated or if there's something about the Text Field with autocomplete that keeps it from working as I expect.
I am working in Apex 4.1 and Firefox 10.0.2.