Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Cross Portal Evaluation


Recommended Posts

Hi All!

I'm hoping someone can shed some light on this situation I've got myself into.


I've got three tables:


One table of Accident event dates with an ID number(Key Field). One record for each event.


The other two tables have the same structure but are Suspensions and Reinstatements.


For every record in the first table I need to determine if it's event date is greater than ANY related Suspensions and LESS than any related Reinstatements.


I've got this on one layout with two portals to the other tables sorted and related with the ID number and a calculation that works fine, but it only evaluates the FIRST row of each portal. I need the calculation to evaluate every line in each portal. Some IDs have one related Suspension and some have 10. Same with Reinstatements.


Maybe I'm going about it the wrong way...


Any help would me much appreciated!



Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use