I have a table consisting of two fields, Full Name and Account Name. I basically use this table to create a value list. In my form on another table I only display the Full Name. The two table are setup in a relationship.
When a user logs onto the system I get their account name and want to use that value to set the default value in a drop-down list field. The issue is I want display the Full Name based not the account name.
Can this be done?