HELP! Creating Records in related portal

[GarrettC]

Boy I just think I get relationships down and I run aground again. Can some please look at this example and tell me what I have wrong.

I have a table named STORY that is linked to another table called STORYversion through a portal.

What is supposed to happen is that when you click in the Story Word field (blue) and enter a word a new record is created in the STORYversion table, along with a unique ID # (left field).

But instead of this behavior the duplicate number is entered into the next record field and a error occurs because it must be unique. When I check the serial # in the STORYversion table it is incrementing as expected but not ending up in the field.

I get the feeling that i am missing something really obvious.

Thanks for the enlightenment.

TEST.zip

[RalphL]

You are using the wrong fields for the keys. Story_ID should be the key field and needs to be added to STORYversion.

[GarrettC]

Ralph, thanks!

I hope this starts to come more naturally.