I've been doing some experimentation with an MSDN article entitled "Creating and Applying an XML Resume Template in Microsoft Office Word 2003". It seems to me that there may be a more direct method of doing multiple detail line reporting in Word that the way we are doing it now. I figured out how to use a query with FOR XML EXPLICIT to generate nested XML structures. Now I need to figure out how to supply Word with a .XSD schema that describes what I have done.

If my XML comes out like this, how do I create the XSD to match?

<clients clientno="234-76-1044 " lname="Crandall" fname="Elizabeth">
  <objectiv objno="ABC-12" title="ABCs" />
  <objectiv objno="BEH-01" title="Decrease Tantrums" />
  <servobj objno="S-06" title="Shopping for room decorations" />
  <servobj objno="B-01  " title="Past Behavior Plans and Results" />
</clients>

TIA
Randy Hersom