3 Replies Latest reply on Jun 8, 2016 1:53 PM by BKamp

    Relationship issue with TO

    BKamp

      Hi guys!

       

      I create the Offerte_Factuur_log table to keep a log of my Invoices (Facturen) and Offers (Offertes).

      A script automatically creates records in this field when I perform certain actions.

      I created a portal window on my Facturen layout with source Offerte_Factuur_log and the log records show up fine!

       

      however, on the Offertes layout, I created a portal window as well, set the source to Offerte_Factuur_log_2 (TO) and no records show up...... I'm lost here. There's definitely something wrong in my relationships, but I have no idea what.....

       

      Thanks !

        • 1. Re: Relationship issue with TO
          coherentkris

          if you are on a layout based on the Offertes TO and have a portal pointing to the Offerte_Facturen_log_2 TO and have an instance of a field from Offerte_Facturen_log_2 in the portal and have no filtering set up in the relationship OR the portal then the only thing that would prevent you from seeing records in the portal is the data.

          Make sure that Offertes::id and Offerte_Facturen_log_2::id_Offertes have values in the records that would actually produce matches to show in the portal.

          • 2. Re: Relationship issue with TO
            siplus

            sometimes people duplicate a portal, change the portal relationship but forget to also change the fields in the portal to reflect the correct ones, maybe is this your case ?

            • 3. Re: Relationship issue with TO
              BKamp

              Thanks guys!

               

              After some checking I found that the source was incorrect.

              I thought I checked it a hundred times before asking here, guess I need some more breaks in between doing this, haha