Hi everyone
I currently have two tables set up on my database, one for products and one for orders. One the products table, I have the names of the products and the category that they are in. What I need is two columns on my orders table, one for product and one for category. Then I need to have a lookup up on the products column and when I add a product from the products tbale to the order table, it automatically fills in the category column on the orders table to say the same thing as what it is on the products table. Sorry if that's a bit messed up, I'm teaching myself to create databases and not long started. Thanks for the help.
I currently have two tables set up on my database, one for products and one for orders. One the products table, I have the names of the products and the category that they are in. What I need is two columns on my orders table, one for product and one for category. Then I need to have a lookup up on the products column and when I add a product from the products tbale to the order table, it automatically fills in the category column on the orders table to say the same thing as what it is on the products table. Sorry if that's a bit messed up, I'm teaching myself to create databases and not long started. Thanks for the help.