Help with simple relationship
I'm not making any headway so I thought I'd go back to the very beginning with just two tables to see if I can do something very simple. My tables are Contacts and Notes.
CONTACTS::_pkCONID is linked to NOTES::_fkCONID. NOTES has a unique serial number __pkNotesID.
I linked CONTACTS as the parent to NOTES as the child. I have a contol tab on the CONTACTS layoul with a portal to NOTES.
There's only one field on the portal called Text.
The goal is to have the user enter notes that combine a timestamp and user stamp with the text from the note.
I can get everything to work but it doesn’t hold onto my GO TO Related Record.
My script is: Go to Layout ["Notes_Utility - Table View" (Notes_Contact_Detail)]
Go to Related Record [Show only related records; from table: "Notes_ContactDetail"; Using layout; <Current Layout>]
Go to Field [Notes_ContactDetail::Text]
But invariable my relationship fails to link the primary key from CONID to the foreign key in the Notes table.
Any idea what I might be doing wrong?