Multiple contacts per record


If you have the 1st row as Company, and there are several Contacts for that company, each in a different department, with different email, and phones, how would you construct that?


I’d have two tables. A COMPANY table and a PEOPLE table and link the two.