1 Reply Latest reply on Jan 24, 2011 6:57 PM by davidanders

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

    KaloaRobinson

      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?