Could an Option be causing my problem

[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?

 

[Guest]

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

 

[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.