Stupidly Simple Relationship Question

[Bachfile]

Hello again,

I keep having a problem Enforcing Referential Integrity which allows Cascade Update on two tables.

The "One" table is a Category table with fields CategoryID (autonum) and CategoryName (text).

The "Many" table is a SubCategory table with fields SubCategoryID (autonum), SubCategoryName (text) and CategoryType (number).

CategoryID and CategoryType are joined in a one to many relationship but Access keeps spitting out this stupid error that the relationship "Must be on the same number of fields and have the same data type" - so in other words, I can only join with enforcement two autonum fields? What about this blurb about same number of fields? what exactly does that mean?

Thanks for your continued support!

Bachfile

 

[Travis]

An autonumber is also a Long Integer.

Make sure that the "CategoryType" field is a Long Integer