portal based on calculation?

[Charlie Butterworth]

I have a plant DNA database and want to show two portals side-by-side to show those DNA's that have been selected for PCR and those that haven't.

My current solution uses two self-joins to the field "Select for PCR" which is either set to "Yes" or "No." The portal on the LEFT shows those records for which "Select for PCR" = "Select for PCR" between the original DNA table and the first of the self-joined tables. The portal on the RIGHT shows data where "Select for PCR" DOES NOT EQUAL "Select for PCR".

In this way, if a record is set to "Yes", the portal on the left shows other that are also set to "Yes" while the portal on the right shows those that are set to "No"

However, if I change to a record that is set to "No", then the portal on the LFT shows "No" while that on the right shows "Yes"

While this is all very logical and makes sense, I would like to force the portal on the LEFT to show records that are set to "No" and the portal on the RIGHT to show only records that are set to "Yes" REGARDLESS of what the current record is set to.

If I could create a portal based upon a calculation such that the one on the LEFT look up Accessions::Select for PCR = "No" and the one on the RIGHT uses Accessions::Select for PCR = "Yes" then everything would be great.

Any ideas?

Thanks,

Charlie

[mr_vodka]

Create two global fields. One that is set to Yes. The other set to No. Have two different relationships for each portal.

One from gNo to 'Select PRC' for the No Portal, and the other gYes to 'Select PRC' for the Yes Portal.

I think this should solve your issue if i understood your post correctly.

[Charlie Butterworth]

Mr_vodka,

Thank-you, your solution works admirably. It makes the layout much easier to understand.

Regards,

Charlie