6 Replies Latest reply on May 19, 2016 3:57 AM by DanielShanahan

    I have a customer database of which several customers have numerous contacts, how can i assign the correct contact to a work order.


      Thanks for taking the time to read this question. I am a novice who has built a workable solution for our business.

      My stumbling block is that on a work order layout, I need to include the correct customer contact including his phone number and email address.

      Where a customer may only have one contact, it is not an issue, but where a customer may have 4, 5 or even 6, I have an issue.

      Currently I list the contacts in a Customer table as contact 1, contact 2 etc with the same for there phone numbers and email addresses.

      Can someone please help me sort through this scenario.

      I hope I have given you enough information.