Dear Friends

My ProductMaster table contains the attributes like ProductCode, ProductName, PackSize,PackType, Price, ManufacturingDate (MFD). The problem is MFD is changing everyday. In this case how I normalise this table. Shall I keep different ProductCode or same ProductCode. (I have a lot of products producing each and everyday). if i keep different productCode i have to make 365 entries per product.

i have to track a lot of reports like sales,sales return, purchase and purchase return based on this MFD date. Tell me how i normalise this table.

it is like products are keeping in Medical shops on the basis of batchNo

thanks
bobbytom