No duplicates in a portal

[Inky Phil]

I have a portal where I display the delivery addresses that have been used in the past for the current customer/dept. combination.

Is there any way of filtering this portal so that any address only appears once no matter how often it appears in the relationship?

TIA

Phil

[Søren Dyhr]

I would use Ugo's method:

Instead of fiscal Year use the address, or rather the ID for the related address record!

--sd

[Inky Phil]

Hi Soren

Thanks for getting back to me on his one.

Can you point me to any links on Ugo's method or explain it a little further cos I cannot read that graphic that you have included

Many thanks

Phil

[Søren Dyhr]

Well basicly is it the same as portalized summaries, but instead of a sum field should you only use one for each address. This means that the calc utilizes the Last over the selfjoin relation, instead of the record where ID is indentical with related ID.

Here is an example where it's used:

http://www.kevinfrank.com/download/repeating-lookups.zip

...although it's overkill in your case. But the relations are there.

--sd

[Inky Phil]

V. Good

Thanks Soren

Phil