AnsweredAssumed Answered

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

Question asked by unclemito on Apr 17, 2016
Latest reply on Apr 20, 2016 by DanielShanahan

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

Outcomes