I am creating a filemaker solution a non profit organization. I have 400 plus member records. These members are separated into 4 groups (A,B,C,D). Each group has 4 sections (A,B,C,D) and each section has 3 to 4 teams (1,2,3,4). Each team has a number of members in them.
I need the records to be sorted correctly when the account holders connect to my filemaker solution using filemaker go via an iOS device. The issue is that I can sort them correctly when viewed on my macbook. But when I connect to my layout remotely using filemaker go, the records are not sorted correctly. I need the records sorted by the following sequence, group, section then team when the layout is viewed using filemaker go.
Any advice will be greater appreciated.