Forms, I think...I'm desperate!

[nah2c]

Hi - new here and am way over my head :banghead: I'm creating a database full of contacts. I have a contacts table with detailed info on each contact and I also have a company table with details on each company - all companies attached to a contact are in the company table plus a few others. I'd like to be able to pull up a company profile and see all the contacts we have associated with that company displayed in a list. How the heck do I do that??

TIA!

 

[David R]

Subforms. You need to have the Primary Key of your Companies table as a Foreign Key in your Contacts table.