Relationship

[KuramaFCPL]

I am trying to Enforce Referential Intergrity on my relationship, but I keep
getting an error message saying "Relationship must be on the same number of
fields with the same data types" Please help. Thank you

 

[Joan Wild]

Likely you are trying to create a relationship between two field of
differing datatype.

They must be the same. For example you can't enforce RI between a text
field and an integer field.

Check the datatypes in the tables. Note that for an autonumber field, you
want to create the relationship between it and a number field of Long
Integer size.

 

[tina]

look at the field(s) that you're trying to link together. what are their
data types? if Number, what are their field sizes?

hth