I'm going to spit this off to the group that specialises in this kind of
thing, however, my first question is "How did you get a connection to mysql
from Microsoft Office in the first place?"

The people in the mailmergefields group need to know that you are doing this
in Macintosh OS 10.4.5 (Unix) using Microsoft Office 2004.

This is a specialist area, and I am by no means a specialist. However, I
think your answer will be something along the lines of "You need to use the
Database toolbar to insert the database into your data source as a Word
table." Once you have done that, you can then query the fields in that
table.

Hope this helps

On 28/4/06 8:37 PM, in article
, "
wrote:

Hi

I'm trying to solve the following.

I have a data source that contains two tables - table one has an id1
and some other fields and id1 is the primary key, table2 has as its
primary key id2 but also contains id1 from table1 for linking.

I want my word document to ask for a value for id2. And the select id1
and id2 if and only if table1.id1 equals table2.id1 and table2.id2
contains the value that i was asked for intially.

or to put it in mysql language

SELECT Table1.ID1, Table2.ID1 FROM TABLE1, TABLE2 WHERE Table1.ID1 =
TABLE2.ID1 AND TABLE2.ID2 = ?

I can access the table, my problem is that I cannot figure out the
proper syntax for MSWords fields

As far as I can tell I should be able to do this using IF combined with
ASK but I've spent the better part of my day not getting any closer att
all.

I would really appreciate any help.

I might add i would like this to be don on saving or printing but only
once for each document .. so if its opened again it will not ask .. in
other words if the fields are filled in dont ask. But I'll settle for
just getting the first part!


--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410