go to related records

[ctls]

Hi,

I've been trying to figure this out for a while now...

I have Clients and Events tables and they are related through Registration -which has EventID(primary key from Events) and ClientID(primary key from Clients).

Each Event has an Evaluation from different Clients. Currently I have different Evaluation-session tables such that a set of EventIDs with the same Session Name(from Events table) are in same Evaluation table. So each Evaluation table has a global field which is Session Name and is related to Events through this.

On a layout based on Clients, I have a portal showing "Registration history" of that Client, i.e Eventcode and other fields from Registration. I want a button "Go to Record" in the portal such that if I click on it, it takes me to a layout with the Evaluation turned in by that Client for that Eventcode.

If the Evaluation tables had global field for Event code and not Session Name, this would have been easy. I could have used the followig script:

If(Registration::SessionName = "ITA")

Go to Layout[iTAEvaluation]

Elseif(Registration::SessionName = "TES")

Go To Layout{TESEvaluation)

EndIf

Go To PortalRow(next)

Here ITAEvaluation would have portal from Evaluation table for the Events with session name ITA. and TESEvaluation would have portal from another Evaluation table for the Events with session name "TES".

But with this script, the records for all the EventIDs with that same session name are shown. I want to filter these records(in the portal) such that the EventCode matches with the Eventcode in Registration history.

I have limited number of Session Names. But EventIDs are added each term. so I cant write a similar script for EventID.

I hope I have stated my problem clearly. And thanks for being patient and reading this. Should I be relatng the evaluation tables in some other way? Is there a script to filter the records from Evaluation table?

Thanks again.