Relationship problem

[cbearden]

I'm getting this message when I try to check Cascade UPdate and Delete. I have already a relationship between the two tables(One to One):

"INvalid field definition "intID" in defition of index of relationship."

intID is what connects my Customer table and Auto table. In the customer table, the data type is an Autonumber, and in the Auto table it is Number.

Could someone help?

Thanks

 

[The_Doc_Man]

Number is generic, could be INTEGER or LONG. For AUTONUMBER, matching fields should be LONG.

 

[cbearden]

The field size is Long Integer. Is that what you mean.

Thanks!

 

[The_Doc_Man]

Yup. Autonumber as a prime key must be matched by Long Integer as a foreign key.

But if the fields in the two tables are the same size, your error is due to something else.

Here's a thought: The key on the "one" side of a "one-to-many" relation must be unique. The "many" side can (should) allow duplicates. Could be an index attribute rather than a field attribute that is choking you.