AnsweredAssumed Answered

Structure of database

Question asked by danherbert on Oct 22, 2009
Latest reply on Oct 22, 2009 by philmodjunk


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!