Going mad....
I have two tables. (brilliant so far!)
The first is a typical client table (tblClients) with the usual stuff in it like name address etc that you would create to form the basis for title, first name last name and address information to insert into a ms word letter. just like the fuzzy green thing!
The second is a document archive table (tblDocumentsHeld) where the clients listed above, store any number of documents. As a legal practice this could be wills, powers of attorney etc. One client can therefore have many documents in this table. (no great shakes so far)
I am trying to create a merge letter in word 2007 that is going to take the client information and insert this as the header, address and greeting based on word merge fields from the access data source. No problem here!
Here the trauma starts...
Also I would like in the same letter to let the clients know what documents they have in the archive.
eg
Address details (from tblClients)
Dear Mr Smith (Greeting from tblClients
We hold the following documents (from tblDocumentsHeld, based on the ClientID)
1. Will
2. Power of attorney
3. Bank bonds
Stuck, Stuck, Stuck!!!!!!!!
Please anyone who cares about taking a humble crazed person out of the doldurms, you're more than welcome to lend a helping hand...