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.