Option 1: Format your field as a pop-up menu
Option 2: Place the related "name field" immediately to the right of the drop down formatted ID field.
So I guess my question is how can I completely "alias" the AccountType ID to display as the AccountType Name to the user, or is this even possible?
Everything you have described sounds right. I think you just have one more step. Add another AccountsTypes::Name field to the layout. Place it on top of the drop-down and size it to fit. Make it inaccessible in Browse mode.
Now when you choose a Name from the drop-down, it will populate this new field and hide the AccountTypes:AccountID value underneath it.
You may still see the AccountID when the drop-down list is displayed. If you find this confusing, change the pen color to match the background.
There are several variations on this…
Thanks for the input! I opted for changing it to a popup rather than a dropdown and it worked perfectly. Gained a little more understanding of Filemaker in the process, in the other suggestions, so thanks again.
Much as I like Filemaker, MS Access has way more options/features for managing multi-column value lists.
I've recently requested the following features from FM inc's feature request form:
The ability to sort on a column if it is hidden.
The ability to base the sort on the order specified in the referenced relationship.
To be able to use auto-complete when first column is a hidden number field.