October 28, 200520 yr 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
October 28, 200520 yr You are using the wrong fields for the keys. Story_ID should be the key field and needs to be added to STORYversion.
Create an account or sign in to comment