Getting error "Invalid field definition 'Customer Service ID' in definition of index or relationship
Posted on 2003-02-22
I keep getting the above error when trying to create a relationship between fields called "Claim ID" and "Customer Service ID". Both fields are Autonumber primary key fields, and I have Enforce Referential Integrity checked when trying to create the relationship.
I tried checking Access help, and all I get is:
· The field name you've specified might be misspelled. Check the spelling of the field name.
· The field type you're using is a Memo or OLE Object, which cannot be indexed.
I'm pretty sure everything is spelled correctly, and the field type is Autonumber, not Memo or OLE object, so I don't think that is the problem.
Anybody have any suggestions?