how can I compare different vendor prices when some same product

[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 (e-mail address removed)

 

[mscertified]

You need a web development forum not an Access forum