1 Reply Latest reply on Aug 21, 2013 9:48 AM by philmodjunk

    Company with Contacts



      Company with Contacts


           I want to make company as a primary contact with multiple contacts within the company.

           I have created a table for Company and another for contacts and linked them, but is it better to have all in the one table.  I have tried all in one table but every time I make a new contact for a particular company it creates a new company.  Is there a technique for this?



        • 1. Re: Company with Contacts

               It depends on the needs of your database and the data you need to record for a company and a "contact within that company".

               In most cases, it will work best to have one table for company linked by company ID to a table of contacts. But in some situations a contact may need to be linked to more than one company. (Such as a contact that manages more than one company or a broker that reps for multiple companies...)

               and then you need a join table.