Filter Duplicates in a portal

[Eden Morris]

I want to remove all duplicates from a portal view. Any ideas?

What I have is many stores grouped together with a multistore ID. I only want one of those stores to show up for each group of stores. so I only want unique values of multistore ID's

Edited September 15, 2010 by Guest

[bruceR]

Post an example please. It is unclear what you're doing with multi-store IDs.

[Eden Morris]

so lets say I have 6 stores

I want to show only one of the stores per multistore ID. I can't use the store number and just show store 1 because there might not be a store 1 it might start at 2 or higher.

I could have a pop up window and then remove all duplicates but Id like to do this in a portal view.

[comment]

Is "multistore ID" a company ID? If so, do you have a Companies table, where each company has a unique record?

[Eden Morris]

this is all in one table. a group of stores makes one company. one store can make one company also if there are no other stores but we can add more stores to that later. if I want to see what other stores are in the same company I just have a portal that points to another table occurrence of the same table related with the multi store id.

Edited September 16, 2010 by Guest

[comment]

Yes, I understand this is all in one table (Stores?). I asked if you also have another table for Companies (and if not, why not). Deduping a portal is not trivial, though it got a bit easier with version 11 - see:

http://fmforums.com/forum/showtopic.php?tid/214715/

[Eden Morris]

That was perfect! thanks!