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

I would use Ugo's method:

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

--sd

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

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

V. Good

Thanks Soren

Phil