Relationship Problem- Same Data Type?

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
 
R

Rick Brandt

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

What "size" of number? It needs to be LongInteger.
 
H

HServ

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

Top