Relationship Problem- Same Data Type?

  • Thread starter Thread starter HServ
  • Start date Start date
H

HServ

I am trying to create a One-To-Many relationship and enforce referential
integrity but I get the error message that the "Relationships must be the
same number of fields with the same data types." I don't understand because
they ARE the same number of fields and data type. One is an autonumber and
one is just a number but I can't change that now! What is going on?
Thank you
 
HServ said:
I am trying to create a One-To-Many relationship and enforce
referential integrity but I get the error message that the
"Relationships must be the same number of fields with the same data
types." I don't understand because they ARE the same number of fields
and data type. One is an autonumber and one is just a number but I
can't change that now! What is going on?
Thank you
Click to expand...

What "size" of number? It needs to be LongInteger.
 
They are both Long Integer. The only difference is that one is an
autom\number and one is only a number.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Relationship must be on the same number of fields with the same... 9
Relationship 2
autonumber relationship 5
Data Type Conflict 7
Question about table relationships 1
Import from Excel 2003 to Access 2003 4
Table relationships 1
Referential Integrity Unavailable 2

Back
Top