I am a newbe to all of this so please bear with me.
I have a membership database that is searchable by state. I also have a fiels that has multi state entries for members that choose to be listed in more than one state.
The problem is when I search this Multi-state field I want it to return all states in order and also sort the results for each state alpha by last name? Does any of this make sense?
Please Advise
Bryan
I have a membership database that is searchable by state. I also have a fiels that has multi state entries for members that choose to be listed in more than one state.
The problem is when I search this Multi-state field I want it to return all states in order and also sort the results for each state alpha by last name? Does any of this make sense?
Please Advise
Bryan