Search results

The Price is Right Len, The ProductID field in the product table is the primary key. The AddressID is the foreign key. The products are being delivered to the addresses, not obtained from them. It's more like an inventory at each address. The price is the same for each product wherever it...

A price to pay Len, Thanks for replying. A price is not already stored in the database. I am a little unsure of which table to add it to. I guess I would add it to the table of products, but as it is relevant to the look-up table for the product field, should I replace the look-up table with...

Dear List, I have made a database of locations. Each location has a subform which lists the "products" at this location. There are only about 5 sorts of product, and these are in a look-up table. I would like to add the price of these products, so that when I open a different form/report, I...