How to use results in one field in another field

[consiglieri]

Hi

I have been doing a lot of "field" work of late. And there is one item
that I have had problems figuring out.

I have the following

{DATABASE \c "DSN=database;" \s "SELECT Table1.Field1 FROM Table1,
Table2 WHERE Table2.Field1 = {FILLIN "Supply a nr"} AND Table1.Field1 =

Table2.Field2}

I would like use to the result from {FILLIN "Supply a nr"} in another
field without being asked again to supply a number.

The second field would simply contain the number supplied when
answering the FILLIN above, there would be no need for a databse query.
I'm not sure how I would go about grabbing the result from the fillin
for something else or if its even possible.

 

[consiglieri]

My mistake .. I'm using Word97 where the databse query is used ... on
the mac the query is to an excel file. On the mac I am using
Office2004. Sorry if this means I posting in the wrong forum.

 

[consiglieri]

Well I finally found it ... was realtively simple... put a bookmark on
what you need and then do {ref bokmark} and thats it. Pretty neat.

Allthough for some reason I cannot get the two fields that are
displayed as xxx -> xxx to have the same format. After every update it
ends upp

XXX
->xxx

with the first line of fontsize 12. The second line retains fontsize 8
as per my settings. Very irritating.

 

[Shawn Larson]

If you add the 'MERGEFORMAT' switch to a field, whatever formatting is
applied to that field will be retained. The syntax for the REF field would
be:

{ref bookmark \* MERGEFORMAT}

No matter how many times you update the field, whatever formatting - font,
point size, color, etc. - you have applied to the field will not change.
The field switch is not case sensitive.

HTH,
Shawn Larson
Mac Word Test