Product Pricing DB Looking to show similar products

[Erin Orman]

newbie here,



we have created a database (electrical contractor) of all our customers, invoices, work orders, etc. and been using since 2000. I have created 'not billed' reports and queries for specific types of jobs. Next step for me has been to create a db for our products we purchase from vendors. they can be the same product from different vendors, or same type of product from same vendor but different manufacturer. We use this to order inventory, check contract prices once we receive invoices from vendor, and provide estimates to our customers so, there are many people looking to search different pieces. I have a good product base entered, and have been looking through sample templates to try to find a way to bring up similar items when you find 'widget1 from vendor1' i would like to click or show somehow 'related items' window?

I may be way over my head, and not speaking technically enough, but thank you for your time.

[orange]

There are a number of sample data models at http://www.databaseanswers.org/data_...all_models.htm

Some of these, or parts of several, should help.
Good luck.

[Erin Orman]

Thank you this is great!