contact list help

[dait]

Sorry for repeating anything that has obviously already been discussed.
I have a fairly large contact list. i also have seperate tables for each type of business i deal with. I have a few contacts for each company. I want to have a look up in my companies table that will just show the contacts associated with that company, ( not just a whole list of all my contacts which it is doing right now)

As you can tell I am only new to access and am struggling to figure it out. Any help is appreciated. I already spent a hour trying to find info in books and internet but too much info out there to find exactly what im looking for.

Thanks again,
Dave

 

[cookiegary01]

Hi,

I presume you are in one table, and want all contacts from 1 business?
In table display mode:
Right click on the field containing the Company.
Then from the menu that appears, select "Selection Filter".

 

[dait]

sorry i am using 2010 version. I have a huge contact list. i also have a huge company list. when i click on contacts as a look up i get the whole contact list. i just want the contacts working for that particular company to pop up.