Problem with Graph/Sorting... Please Help.
New here and to FMP. Nice forum and people.
I have a question. In my database i have 500 records. On my "home layout" i have created a Graph so i can see how many people come from which city. Everything works fine until i go to other layout ( and check let's say his/her information). In my home layout i have sorted all records. When i go to other layout and go back to home layout the sorting is gone and respectively my graph is all messed up(showing 500 record rather 20 cities).
Could you please help me with this, do you think i should create a script to sort every time go back to home layout or i can do something else? i will really appreciate it!!!