I am creating letters in my database which mail merge fields into it. Easy enough. My question is, I'm debating what is the best way to have users enter contat details for clients. As they can have more than one contact number and type I was considering making a contact details table and having a field for the details (Telephone number) and then the type of contact (home, mobile, work, etc). But if I use this method, how do I mail merge the info into letters, say if I want to mail merge the clients home phone?
Can this be done this way or is there a better way to enter this information?