AnsweredAssumed Answered

Help with simple relationship

Question asked by 4justme2 on Feb 25, 2012
Latest reply on Feb 26, 2012 by 4justme2

Title

Help with simple relationship

Post

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>]

New Record/Request

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?

Outcomes