I am driving myself mad trying to understand this simple little detail. I have a table / layout "Req" that has:
What I am doing is create another table and layout NoteReq. Fields are:
I have a button that has a script that copies __pkReqIndex, RequestNo and PO from Req and paste them into NoteReq. Then in Req I have a portal to see all notes attach to Req. and click to read the note.
But do I need to copy all that data over to the notes field or can it be linked. I am pretty sure it can be linked but not understanding how. How do I actually link them together and beable to see what PO Request No and such on the Note Layout pertaining to the note?
Set var [$$RQ; value:tblReq::__pkReqIndex]
Set var [$$RN; value:tblReq::RequestNo]
Set var [$$PO; value:tblReq::PO]
Go to Layout ["NoteReq" (tblReq)]
Set Field [NoteReq::_fkReqIndex; $$RQ]
Set Field [NoteReq::_fkRequestNo; $$RN]
Set Field [NoteReq::_fkPO; ::$$PO]