Option list generated though 2 relations and a dependent variable
So I was modifying some code recently to generate an option list based on alias groups and a dependent field. I managed to accomplish this functionality but it works by displaying the persons username. There is a table that contains both username and full name, but I've been unsuccessful at utilizing it to convert the usernames generated into the list to their real name counterpart.
Tables:
ASSET
- AssetName
- AliasGroupName
ALIASUSER
- dAlias (same as AliasGroupName in ASSET)
- dUserName
USER
- dName (same as username for ALIASUSER)
- dFullName
My current setup is having the option list field populated with a view based on the ALIASUSER table.