1 Reply Latest reply on Oct 28, 2013 4:50 AM by saigopaldas

    Help!!! Having trouble displaying related records

    JodieWeston

      Title

      Help!!! Having trouble displaying related records

      Post

           Any advise would be really appreciated.

           I have 3 tables: shot, bid and bid line

           On a layout displaying records from the 'shot' table, I would like to have 2 portals 1) 'bid' and 2) 'bid line'.  There will be multiple 'bid line' records for each 'bid' record.  Is there a way of displaying (and creating) in the 'bid line' portal, records that are only related to the current selected 'bid' record.  'Bid' and 'Bid line' are related via the bid serial number.  

           See attached - 'Bid' is on the left and 'Bid lines' is on the right.

           PLEASE HELP!!!

      example.png

        • 1. Re: Help!!! Having trouble displaying related records
          saigopaldas

               Here "Bid" and "Bidlines" are related.
               So "BidLines" table will have a foreign key "For_BidSerialno" (suppose) which is storing the Primary Key of "Bid", lets say "BidSerialNo".

               On "Shot" , a global field can be created lets say "BidLine_global" .

               A relationship between "Shot" and "BidLines" can be created .
               Shot::BidLine_global = BidLines::For_BidSerialno

               When detail button , on BID portal is clicked ,
               a script can be called which will store the BidSerialNo in BidLine_global.

               There by the BIDLines portal will display the related records of BidSerialno.

                

               Thanks