I have two related tables: Requests and a custom users table. It's a N:1 relationship. In the custom user table I have the user's full name as the primary name column. I also have the email as another column.
In the Requests form, I have two lookups to the same custom user table: Requester and Requester email. The user manually selects the Requester, then I have a javascript webresource that uses
XMLHttpRequest() to use the Requester value to select the email, and set the value to this Requester email field. But the field still shows as the Requester instead, even though I am still able to get this email field to do something else with it and it works. But I just want to know how to get it to show the email column instead of the primary name. Thanks.
