I think I see what you are trying to do, but personally, I wouldn't.
what you would be doing is storing redundant data in your table.
your products table shouldn't need producttypeshortname as a field, as this information is already stored in your product type table and linked to your products table by producttype (producttypeid??)