I am trying to create an iTunes-like interface to act as a front end to several databases (Magazines, Issues, Competitions). The idea being the user can click on a portal displaying Magazines which will then create a key for the next portal displaying the years that magazine has been published. This continues onto Issues published in that year and onto competitions run in that issue. I am trying to achieve a drill down like action where the user by clicking is filtering down the list of records.

My problem is that when the user clicks on the Magazine Portal Row all the issue records for that magazine show in the year portal. Meaning there are duplicates displayed instead of only showing a single entry for each year. I want the portal to display only one occurance of each year so that when the click on it the issues for that year display.

I am currently storing the year field in the issues database.

Any ideas on how to tackle this one?

Hi,

Mark the first or Last issue for each magazine/year with a 1.

Then a calculation

cYearKey = Choose(last;"";Year)

Base your relationship on this key rather than the classic key.

As for the initial Mark, this would rather be made by a script, as related records calculation wouldn't be indexable.

HTH

Thanks for your reply.

I actually worked it out before reading your reply by doing something very similar to your suggestion.