I have a file (FMPro 10) that holds Customer Information records and a file that holds each Customer's Service records. Each service can fall in one of the three categories. Category A, Category B or Catgory C.
I would like to set up three tabs (one for each category) that would list only the services that fall under the coresponding category (tab) for a particular customer. So that an user could click betwenn tabs and you would only see the service under that category for this customer.
I think I need to create a self joined table using Customer ID and Category field but I am lost as how to go about seting the "filter for a tab.