AnsweredAssumed Answered

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

Question asked by underthepump27 on May 17, 2016
Latest reply on May 19, 2016 by DanielShanahan

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.