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??