relationship between tables

Hello -
am attaching database
2 tables categories and products-
If you open categories - you will see a plus sign and be able to see record related from products table.
I created categories2 table and products2 table and tried to do same thing-
( I usually create joins ( relationships) in queries)
If you open categories2 you will see plus sign - but it gives error "the expression is typed incorrectly or too complex...."
can you tell me how I can make these 2 tables like categories and products?
thank you
test-example.accdb
davetoughAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
RehanYousafConnect With a Mentor Commented:
Your CategoryID in Products2 is actually CategoryName in Categories2
test-example.accdb
0
 
RehanYousafCommented:
CategoryID in Categories is Number format and Text format in Products2

Change CategoryID in Products2 to Number and hopefully it will start working
0
 
davetoughAuthor Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.