Hello,

An extract of my current database :
http://img150.imageshack.us/img150/1...agramexpb2.jpg

there are two different types of product that the database stores: packaged and fresh. This set-up is fine until i've realised that each store has a different price(PricePU) for each fresh products but has the same price(PricePU) for packaged stuff, making this set-up ineligible.

My initial thought was to simply transfer the PricePU attrribute to tblStoreStock, however, this could lead to inconsistencies for prices of packaged goods as well
My second idea is to create two different product tables (f_tblProduct & p_tblProduct) linked to f_tblStoreStock and p_tblStoreStock respectively. This set-up however could lead to the Primary key in each table (ProdCode) to be duplicated.

Are there any better solutions I cud do? if not whihc solution do u think is better?

Thanks in advance,