1 2 3 Previous Next 33 Replies Latest reply on Jul 31, 2010 9:08 AM by joan

    How to connect 2 fields in  table in 2 portals so only one record opens not all in scroll?

    joan

      Title

      How to connect 2 fields in  table in 2 portals so only one record opens not all in scroll?

      Post

      I would like the Notes field be connected to / to open / when I enter a new call. 

      Right now I need to scroll down the notes portal to find notes relating to a specific call. 

      I worked in windows. Had sub forms.  CallListSub and Calls  - Form![Cases Form]!Calls.Requery 

      Call Table is linked to Cases Table via RS_File_No

      On my main form, Cases, I have a

      portal to Calls Table and another

      to Notes which also contains Call ID that is placed below the Call Portal on my Cases form.

      Each portal contains a scroll bar.  

      Relationship is via RS_File_No.

      Call ID field is auto number. 

      Thank you.

      Joan 

       

        1 2 3 Previous Next