relationship between tables

davetough
davetough used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
RehanYousaf

Commented:
CategoryID in Categories is Number format and Text format in Products2

Change CategoryID in Products2 to Number and hopefully it will start working
Commented:
Your CategoryID in Products2 is actually CategoryName in Categories2
test-example.accdb
davetough

Author

Commented:
thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial