I just joined, still new to Access but up to Expert Level 3 in Tutorials.  I am trying to create an office management/practice solution for my small law office.  Two questions, when I set up tables to show my clients and their doctors it seems that two tables will not be enough.  One table holds the clients and their info and the other holds the doctors and their info but since each client may have many doctors and each doctor may see many clients it seems that I will need to set up another table just to keep track  of the doctors that each client sees.  The tutorials are excellent, but I am only up to Expert 3.  Can you suggest a specific tutorial to help me.  The second question is about creating form letters,motions,pleadings using access.  I assume it would be through some type of menu form to choose the type of document to create (ie. pleading or letter etc.) and then a merge with ms word?  Do you have tutorials re this issue?

---

Reply from Alex Hedley:

You'll be after a Many-To-Many Relationship covered in Expert 7
Just continue with the lessons and you'll get there. I wouldn't advise skipping any.

Forms and Reports are covered throughout the course.

Access Expert 19 for Mail Merge