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

    Company with Contacts

    doorkitltd@gmail.com

      Title

      Company with Contacts

      Post

           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?

            

           Eugene

        • 1. Re: Company with Contacts
          philmodjunk

               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.