Multiple people with one company, people and companies are seperate tables.
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?