i have table in which all cutsomer information is displayed. In that i have put a portal which displays all their visits to the store. I want to generate a report which will help me look up all the customers which have come into the shop that month.
So my table is called ShopData and the field is called Date of Visit. At the moment it is just pulling random files. I am using filemaker13pro
Also how can i see who is due for an appt next month at the shop. This is also in the table SHopData and field called FollowUp. Currently i can manage to pull all the follow ups which are required but i would like it so that everytime i click on it is shows me the next months only.
I cant seem to get it to work. Would very much appreciate if someone could help me write a script.