Portal Filtering

[kuma_24]

I have a database of every race ever run in the NASCAR Craftsman Truckseries. The db that holds all the race information is called "races". I have another db which shows the complete driver history for each driver...total top tens, wins, top fives, etc. I want to put a portal in the "driver" db which will show me how say driver "Travis Kvapil" did at every track he has ever run on. The problem is if I put the field "races::track" in the portal then I will get "Daytona" three times since he has run there in each of the last three years. So it looks like this...

Daytona

Daytona

Daytona

How can I make the portal work to get just one Daytona instead of three?

[dbruggmann]

First you have to decide which of the three Daytona races you want to be shown: The last one? first? Fastest?

Accordingly to your decision you than create a new relationship between the two files based on (probably) two new calculation fields. What they look like depends on the answer to the above question. Your goal is to define a calculation that only matches one of the three race records above