setting up a custom sorting order
I'm new to using file maker pro. I am trying to order the files in a database. We check fire dampers for different buildings every five years. sometimes new dampers get added and a record has to be made for them. This record appears at the bottom of the list. I have tried sorting the list to get the new dampers added. The problem with this is that it mixes up the floor order of the building. We list ground floor first and then put floor 1, 2, 3, .... When I try to sort it puts the ground floor on the bottom of the list. I want to make a custom list that tell the sort to put the ground floor first then to sort by numerical, or alphabetical order. It seems like it shouldn't be that hard to do, but I can't figure it out. Is there any way to resolve this problem?