In a table I have the following records:
On a layout I have a three portals. The first one lists the food categories. When I select a category, say meat, the second portal should just show one of each food type for that category. So if meat is selected then the second portal should just show: Beef and Chicken. As it is, it is showing Beef, Beef, Beef, Chicken and Chicken since I have five records with category = meat.
What do I need to do so that in the second portal only Beef and Chicken appear?