Vendor Contact List

[SuperCoog]

Hello all,

I am a new user of Access, and am not well versed in it just yet, so bear with me. I have experience with Excel however.

I work in an estimating department for a construction company, and we frequently will go to vendors to get pricing on products. We have a large list of companies and our preferred contacts, their industry specialty, etc. What I want to attempt to do is create a list where I can filter very easily by all of the different criteria of the vendor (location, item(s), name, etc.)



My main objective is to be able to input a few variables, such as item and location. Keep in mind some vendors will provide item a, b, and c, while others may only provide a. Frequently we need to use local suppliers, so I am aiming for a way to just input a few things and have a filtered list that meets my criteria.

Any help would be greatly appreciated.

[CJ_London]

sounds like you need a minimum of 3 tables to create what is called a many to many relationship

tblVendors
VendorPK autonumber
VendorName text
Location text?
...
...

tblProducts
ProductPK autonumber
ProductName text
...
...

and to join them together

tblSuppliedBy
SuppliedPK autonumber
ProductFK long (links to tblProducts)
VendorFK long (links to tblVendors)

You may want additional fields in this table - such as price, lead time etc

you may require additional tables (for example vendors may have multiple sites, multiple contact details etc). You know your business, if one of your suppliers is a national chain, can prices vary from branch to branch?