6 Replies Latest reply on Apr 20, 2016 6:19 AM by DanielShanahan

    How to organize a Vendor Contact Table for Vendors with Multiple Contacts

    unclemito

      Hi,

       

      1. Running into problems with setting up my Database with vendors who service multiple customers. A vendor will usually assign a customer manger to oversee one or more customers thus having Multiple Contacts for a single vendor.
      2. In the vendor table, in terms of organizing the data
        • Should I give each vendor their own record (Vendor A) and somehow put the customer manager in their own fields?
        • Or have a record for each subdivision of that vendor (Vendor A - Customer A)
      3. How do people handle this?

       

      Regards