Member Avatar for 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?

  • 2 Contributors
  • 1 Reply
  • 86 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by tesuji
Member Avatar for 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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.