Okay, I won't change the setting -- thanks for zoning in on my question!

BTW, my experience with relational databases (I'm not a programmer!) shows that primary keys should always be unique. Wouldn't you think that the Products table would have a one-to-many relationship with Product_categories?

This would allow the setting of product_model to be unique. Hmmmmm

Anyway, that's not how it's setup at this point so I guess I'll have to trust my data entry clerk not to double-enter -- hmmm...what if my vendor's inventory update has a duplicate product_model # ... I wonder what will happen...

ya see, I'm only uploading the quantity/pricing for my products so category is never a field being compared. Hmmmm