very basic field display question
i'm new at this, this may be a silly question. i have a field that holds the type of an account, the accounts are coded as simple numbers, 1 to n. i've created a table that relates the account number to the account information, including the account display name. when the user sees an account, i want the name of the account to display to the user, not the number. right now i can get a dropdown menu to show the names of the accounts, but the field seems to only show number. there has to be a way to show the name, even though the underling stored data is an index to the account.
i hope this is clear.