Issues With Inserting Item

[c_shaft05]

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?

[tesuji]

Hello

Because both products differ in an important property they must have different part numbers. So you are able to manage different quantities, deliverers, prices, taxes etc.
You may put them into same category, for example "hard disks" to get a list of all hard disks if necessary.

krs,
tesu