• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 319
  • Last Modified:

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
0
davetough
Asked:
davetough
  • 2
1 Solution
 
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
 
RehanYousafCommented:
Your CategoryID in Products2 is actually CategoryName in Categories2
test-example.accdb
0
 
davetoughAuthor Commented:
thank you
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now