Before I continue, quick explanation:
product table
pid (primary key), pdesc (Product discussion), and pquant (quantity of product).
I then link it to sub_category which determines if it is where it falls (AKA SODIMM or DIMM).
Now, I have duplicate product descriptions (160GB HD, for example.) We have 2.5 inch versions and 3.5 inch version, in which case we have different quantities of each. I didn't set the pdesc as a primary key, so theoretically since each product is described by the pid, i should be able to have duplicate pdesc but it isn't working.
Any ideas?