Share via

Relationship must be on the same number of fields with the same data types. (Error 3368)

Taylor, Serena M 0 Reputation points
2025-11-02T15:45:03.8866667+00:00

trying to create a relationship for access database and it is giving me an error message

Microsoft 365 and Office | Access | For home | Windows
0 comments No comments

Answer recommended by moderator

George Hepworth 22,855 Reputation points Volunteer Moderator
2025-11-02T16:43:40.7066667+00:00

The answer to your question is in the error message.

To create and enforce a relationship between two tables, that relationship must be on fields with the same datatype: Number to Number, Short Text to Short Text with the same number of characters in each value, and possibly other datatypes although that would be highly unusual.

So, look at the fields for which you are trying to establish a relationship. Are they both Long Integers? Both Short Text? Something else?

Also, you'll want to be sure that fields which are designated as the Primary Key for a table have the unique property set true. The related field in the second table doesn't need to be unique and generally would not be.

Maybe a screen shot of your tables in design view, along with an explanation of the reason for the relationship, would help.

Was this answer helpful?

0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.