AnsweredAssumed Answered

Need help with muliple portals on same layout

Question asked by donjuancarlos_1 on Aug 9, 2012
Latest reply on Aug 9, 2012 by donjuancarlos_1

Title

Need help with muliple portals on same layout

Post

I have a quotes dB.  Each quote can have multiple buildings, each with its own line item.  It is set up like this:

 

Quotes                                                  Building                               Line Items

ID  <------------------------------------> Quote ID

CurrentBuilding <----------------->Building#

                                                    BuildingID <-------------------->BuildingID

 

 

I have a layout that shows the quote, a 1-row Building portal and a line items portal.

What I want to be able to do is have the quote automatically go to Building# 1 when a user opens a quote.  Users also need to have multiple quotes open simultaneously.   I tried OnRecordLoad and OnLayoutLoad scripts to reset CurrentBuilding to 1 but the script triggers too much, not just when I load the record.  Hints?

Outcomes