I have two tables Orders and Contacts and I'm trying to use a popup list for a field named FullName on my orders form. I want to populate the FullName field from the Contacts table. I have setup the relationship and I can get the list to populate but when it pops up it is in sort order by CustomerID and I want it to be in order by LastName, FirstName (which is a calculation in my contacts table). Am I having this issue because the FullName field is a calculation?
Is it possible to have this popup list sort by LastName, FirstName? Please see attached picture.