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 can just add a product to a customer but the order is not connect to the customer, so when I choose the customers name from my tables drop-down I can still select all the orders, but this is not correct because this customer did NOT make all the orders. This is essentially what I want to do connect products to customers, and customers are connected to orders. That is basically it hopefully I explained myself. well.
I included a picture is you look the customer "Tim Sanders" can choose all the orders, but he has NO order so I don't want him to be able to choose an order. Maybe there is a better and easier way to do this please let me know. All suggestions are really welcome.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
zzounds
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 can just add a product to a customer but the order is not connect to the customer, so when I choose the customers name from my tables drop-down I can still select all the orders, but this is not correct because this customer did NOT make all the orders. This is essentially what I want to do connect products to customers, and customers are connected to orders. That is basically it hopefully I explained myself. well.
I included a picture is you look the customer "Tim Sanders" can choose all the orders, but he has NO order so I don't want him to be able to choose an order. Maybe there is a better and easier way to do this please let me know. All suggestions are really welcome.
Kind regards,
Anthony
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.