Relationships Error

Question

I am trying to update the relationships between my tables (referential integrity and cascade) and I keep getting an error that says "Relationship must be on the same number of fields with the same data types."  I don't understand what this means.  Both  parent field and child field are a number field.  I have other tables where the relationships and integrity are intact, but it doesn't seem to be working for a few select tables.

Answer 1

Saying they are both "Number" is not enough. The subtypes need to be the same as well. For example two integers, or two long integers, but not a double and a single.

Answer 2

Is the parent field set as a PK or unique index? If its not, that could cause that message? Also Number has many subtypes So if one I a Number>Long Integer and the other is a Number>Integer. that would cause a mismatch.

Answer 3

Got it, thanks.

Answer 4

As seen in the picture below, I am trying to make a relationship between HMISID and HMISID in two separate tables.  I have confirmed that they are both number data types.  Is there something else I'm missing here?

Answer 5

Let's pick that apart:

> Relationship must be on the same number of fields

This means you cannot have a relation from one field in one table to two fields in another table. Probably not your problem in this case.

> with the same data types.

This means that the fields in both tables must have the same data type, meaning both integers, or both text, or both dates, but they have to be the same.