How to connect 2 fields in table in 2 portals so only one record opens not all in scroll?
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.