Search the Community
Showing results for tags 'relatioships'.
Found 1 result
-
Customers, orders number, order number to products
zzounds posted a question in Tables, Views and Relationships
Hi guys, Please have a look at the picture it makes it more clear. hopefully someone can help with this simple question. So we have a "Customer" making an "order" this "order" has different "products". So 3 tables. When I connect Customer table to order table, no problem, one customer can have multiple order, when I connect orders to products, I want to be able to chose a customer and only see his orders in the products table. At the moment I can select the customer but I get to see all orders, I want to only see his orders. All this in the table. At the moment it seems that I