Error generated when I made a foreign key to allow duplicate indexes

[Lou_Reed]

When I selected the foreign key and changed it to : indexes (duplicates possible) and put it in a table in the relationships window everything was okay. However when I selected the two lower boxes in the edit relationships window. It gagged on the first one, but not the second.



The first, Enforce Referential Integrity was fine, but the second, Cascade Updated related fields, was not. It generated an error:

Invalid field definition, ****, in definition of index or relationship.

What is it complaining about?

The third checkbox was fine and generated no complaints.

R,

Lou Reed

[June7]

I believe Cascade Update would be set on Primary key. This would allow a non-autonumber primary key value to be edited (maybe change "ABC1001" to "ABCD1001" and that edit would 'cascade' to all dependent records.

[Lou_Reed]

So uncheck that second box, Cascade Update?

Also, I am not following your reasoning. In all of the tutorials, all three boxes are checked. None is left out. So what makes this different?


R,



Lou Reed

PS. When I unchecked the second box it gave no error message.

[June7]

Okay, my bad. The setting is on the link, not the field or table.

Don't know why you have this error. I cannot replicate.