Hi Contro,

OK, I read your message to Doug and you mention "very exact formatting".
Before we get too deeply into this approach, could you describe what kind
of formatting is meant?

IF fields do a fairly good job with Font formatting. Paragraph formatting
can get a bit "iffy" under some circumstances. If things are really
complex, a macro solution might be the better approach.

As to the article and the example:

I see this is an older article. A better example is here
http://support.microsoft.com/?kbid=211303 (thanks for asking and thus
bringing this to my attention). This article should make more sense (and
I apologize for the confusion due to the old article!)

Thanks for you reply. My database is fully normalised (so far as is
required anyway! I'm no expert on it, but it's all up so the
relationships are right and the primary and foreign keys are in place).

The code of the knowledge base example is:

Employee Project
{MERGEFIELD Employee} {MERGEFIELD Project}{set duplicate {if
{MERGEFIELD Check}="1" "off" "on"}}{nextif {mergefield check}=""}{if
{duplicate}="on" "P
t{MERGEFIELD Project}"}{set duplicate {if {MERGEFIELD Check}="1"
"off" "on"}}{nextif {mergefield check}=""}{if {duplicate}="on" "P
t{MERGEFIELD Project}"}{set duplicate {if {MERGEFIELD Check}="1"
"off" "on"}}{nextif {mergefield check}=""}{if {duplicate}="on" "P
t{MERGEFIELD Project}"}{set duplicate {if {MERGEFIELD Check}="1"
"off" "on"}}{nextif {mergefield check}=""}{if {duplicate}="on" "P
t{MERGEFIELD Project}"}

From what you mention, I see that the code basically looks for items
which have a primary key - foreign key match (subjects that belong to
the same student). I'm just not sure how to use this code to my
situation though. Above, the code seems to be looking for a number in
a "check" table which is 1; I've no idea why. Also, I do not
understand all the "off" "on" business at all or how they relate to the
"1" that is specified and whether they need to relate to a 1, or if
this is just something that is only part of this example and isn't
necessary (not something I'd need to use in my own database).


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)