Using the If function in one portal row reference another portal row gives me only the top portal row record

[mastreck]

I am using the "if" function in a calculation field. That field is located in a portal. It gets the response for the "if" calculation but only from the first/top record in the other related portal. How do I have the "if" function calculation search through the whole portal (all related records) to get a response? I will copy and paste the calculation that I am using down below if that helps.

If (Individual ID=Small Group Male 2::Individual ID Male and Small Group ID=Small Group Male 2::Small Group ID;Small Group Male 2::Role)

[Vaughan]

The IF calculation needs to be in the related table.

[mastreck]

I'm not sure what you are stating. The portals and tables are related. The "if" calculation is in a related table. I am trying to get the response from the other portal. I am able to get a response, but only from the top record, it does not search through the whole portal or all related records.

Edited March 13, 2008 by Guest

[mr_vodka]

A portal is merely a window into the related records. So if you are in a parent layout with one portal showing the related records from one table occurrence, you can see all the related records.

However, if you are coming from one of the child TOs, then through the parent record, and then to the other related child records, it is basically going from the first record of the child TO, then to the related parent first record, and then the other child TO's first record.

So if you want to relate the records from the records of one portal to ther other portal's related records. Since most likely they are both joined to the parent record by the parent's foreign key, you should be able to join the two tables together with another TO keyed on the foreign key.

Edited March 14, 2008 by Guest
deleted extra text

[mastreck]

They are two child tables that are related through a direct relationship with each other. I think a part of your reply was cut off at the end.

Edited March 14, 2008 by Guest

[mr_vodka]

You can use the List () function to give you a list of related IDs. That being said, perhaps you may be going about this the wrong way. Why dont you post your file.

[mastreck]

I tried using the list function like you said. It gives me the correct response, however I get a leading "0" with a return before the response and a "0" after the response. How do I exclude the extra characters?

List (Individual ID=Small Group Male 2::Individual ID Male and Small Group ID=Small Group Male 2::Small Group ID;Small Group Male 2::Role)