I am trying to use an autocomplete text field that can be used to populate other fields.
I have seen this demonstrated in version before 18.2 with the following approach:
SQL Query:
SELECT full_name||'<user_id>'||user_id||'</user_id>'
FROM app_user
Then in the page CSS inline:
user_id {
display:none;
}
This hides the user_id in the text field search but then you can use code (DA) to get the value of the user_id.
However, since 18.2 (i guess something to do with JET implementation) I cannot figure out how to do the same thing.