I would like to put text with << vfp fields and functions >> into a separate table, then use this data with textmerge. What I can not figure out how to do is then use the memo field data in the PRG with TEXTMERGE. For example, if I have the following data in my memo field:
\Based on the character of the hydrogeologic factors around the setting; the nature of these potential contaminant sources, and their proximity to the well; and the physical integrity of the well; this well has been determined to have a << iif(watersrc.net_score = 3, "HIGH", iif(watersrc.net_score = 2, "MEDIUM", "LOW")) >> susceptibility to contamination.
\
\(*) Estimated value based on Best Professional Judgement.
\
How would you write the PRG so this is interpretted correctly?
TIA
Mark McCasland
Midlothian, TX USA