I have a userID (int) and I lookup the user_name on a form. I want to display ONLY user_name (“Ted Smith”) instead of having the integer in the field and the user_name next to it. Is this possible? It is for informational purposes only on the form.
Edit the Field.
Check the box that says: Lookup settings
Type in your sql:
SELECT CONCAT(first_name,’ ’ ,last_name) FROM users_table WHERE usersid = [userID]
LIMIT 1
Choose the Connection1
Should be all set
1 Like