Hi All,
Sorry if this is a bit basic...
I've got a simple DB that has a table with a list of products (names, UOMs etc...) and i've which is linked to another table (called orders) where I want to select from that list of products and enter my own quantities. How do I set up the orders table to allow me to do this? I've got it so I can link products to the order via a lookup but I can't seem to set my own quantities against each item.
The table(s) need to related in a way that will allow me to raise an order, select a product from the 'Product' table and enter quantities against each related product. These quantities could, obviously, be different from order to order... is this (relatively) simple to achieve?
Cheers,
Jon