how can I compare different vendor prices when some same product

  • Thread starter Manager that needs help
  • Start date
M

Manager that needs help

I am currently building a website and to give the lowest prices to customers
I am setting up a database with a multitude of vendors offering many
different items for once particular industry. I made a primary key using the
Manufacturers SKU on all the tables and linked them under relationships.

I am trying to find a way: when the same Manufacturers SKU is found on any
(and all) of the tables (vendors price list) it will highlight it in bold or
if I am really good create a new table with the new complete price list and
Manufacturers price list? That would be so nice! I'd even pay for it! Please
help and send answers to [email protected]
 
Top