Could an Option be causing my problem

B

Bob Richardson

I'm getting the "Relationship must be on the same number of fields with the
same data types" error message. The one-to-many link between Student and
Record is set up.


Student Record Class

PERSONID ATTENDID ATTENDID
PersonID TIMESLOT

All fields are type "Number." Student and Record are linked, one-to-many,
using PERSONID. I'm trying to set up a one-to-many link between Record and
Class. All Keys to these tables are the capitalized words. The error msg
comes when I try to link Record to Class with ATTENDID, to get a one to many
relationship. Is it possible that there is an OPTION I've set that's
causing this problem?
 
K

KARL DEWEY

You have Class fields ATTENDID &TIMESLOT as caps so does this mean they are a
compound key field?
 
B

Bob Richardson

Yes, they are compound keys. My problem was that some numbers were long
integers, and some were doubles...thus not the same data type, although not
immediately evident to me.
 
Top