AnsweredAssumed Answered

Portal filter

Question asked by Kat11_1 on Aug 19, 2011
Latest reply on Aug 19, 2011 by Kat11_1


Portal filter


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.