Form Letter Quandary

[OxDavis]

Ok, I have a DB containing data (name and address) about a client's parents, psychiatrist, and school. When it comes time for the client to have a review meeting, I want to be able to generate a form letter to all these parties, but I'm not sure how to do that with my current DB configuration. Right now I have the Psy, School, and Parent Data in separate tables. Should I combine all these tables (name and address info) into one and define a 'type' of contact rather than splitting them out? That sounds like the most obvious answer, but I 'd like to hear some opinions before I go galavanting through my DB deleting tables

 

[KeithG]

Make a query to display the data you want. Then create your report/letter or you can use mail merge with Microsoft Word to write the letter.

 

[OxDavis]

Ok, time for Question 2. Any hints on how I can filter the report to only generate form letters for the record I am viewing on my form?

OnClick
Do.Cmd RunSQL "blah blah blah"

Where does the filter go?

Thanks in advance,
Ox