While some brains are malleable enough to navigate the murky intricacies of FM7's relational realms, my brain skids and crashes noisily into unforeseeable barriers, shrapnel and debris flying everywhere, that sort of thing. More accurately perhaps, I feel like a 3-dimensional thinker trying to navigate in 5-dimensional mind-spaces. Perhaps a Queue-like superhuman can point the way once again!

Two tables:

1) People - Person ID (auto-serial), Name

2) Places - Place ID (auto-serial), Person ID, Place Name

A portal on a People layout contains a list of all places the person has visited, where (People::Person ID = Places::Person ID).

Person #1 has visited Chicago, Seattle, Chicago, New York, Seattle.

Person #2 has visited Seattle, Fresno, Seattle, Seattle, Fresno

How do I make a portal on the People layout that condenses similarly visited places? I.E., Person #1 sees "Chicago, Seattle, New York", while Person #2 sees "Seattle, Fresno".

Is this possible without creating a "Cities" table?

The attached attempt seems like it should work, I'm able to indicate when a record is unique to the whole list, but not per person.. kinda useless to include, but a starting point for anyone who wants to take a whack...

Lost in space,

n1k0

Portal Limiting #2.fp7.zip

Well, I don't have enough time to test portal ideas. But I did create an easy Valuelist solution.

Portal Limiting #2.zip