AnsweredAssumed Answered

Multiple people with one company, people and companies are seperate tables.

Question asked by KaloaRobinson on Jan 24, 2011
Latest reply on Jan 24, 2011 by davidanders

Title

Multiple people with one company, people and companies are seperate tables.

Post

Not too sure if I'm doing it right, but this is what my database is:

Two Tables: (1) Contact list (2) Companies.  I need a profile for each individual person, as well as a profile for the company as a whole.

I'd like to be able to have the employees at a certain company automatically populate when I type in the company name in the Companies table, but also some sort of drop down menu that shows a list of only companies I already have employee profiles for.

I'm not even sure I'd taking the right route to my database.  Perhaps someone can help me out?

Outcomes