Hide "doubles" in portal

Discussion created by Boutsy on Sep 4, 2014
Latest reply on Sep 5, 2014 by user19752



It should be simple, but I just can't find the way to do it....

I'm using FMP13 and I would like to make a portal in wich only 1 record of each "type" is shown. Let's say we get the data from a table "X" with the field "First Name". In that table we have 5 people with the name "Bob", 3 with the name "john" and 1 with the name Alan.

I would like to have a portal in wich you see the names Bob, John and Alan only once. It should give the same result as making a value list that refers to the table "X" in which you select "Use values from field" X::First Name. Doing this, you would get a list with only Bob, John and Alan.

Can this be done by filtering??