AnsweredAssumed Answered

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

Question asked by joan on Jul 16, 2009
Latest reply on Jul 31, 2010 by 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 

 

Outcomes