Structure of database
I need some advice on how to structure my database to enable me to gain the following results:
1) To be able to create prod_stock_cost records in a portal in the products layoutbut with it only allowing me to create records based on the relationship of the product to the supplier
2) To create records in the prod_stock_cost table using a discount set in a new table which I can call supplier_category_discounts where I can set discounts on products in a particular category by a particular manufacturer which will then create records in the prod_stock_cost automatically for each product in the category at the set discount (normally a %)
Been strugggling with this but need to sort out my master product file so I can use it for all our products!