Is ODBC the best for this?

[elanahy]

Hi. I’m new here.

I have a database that eventually is to run on FileMaker 8 server. One of the part of the solution the user wants are these forms. They have these forms in Microsoft Word and what they would like is each new record to generate the forms in Word (not in FileMaker) and then have the form file saved for each record that they can then edit. (They have fields on the form they do not want stored in the database)

I thought the best solution for this would be to do it connecting with ODBC drivers. I finally got the drivers installed properly but still have not been able to get the connection to work properly and this is just in a stand alone setup. So after reading the posts on FM8 ODBC issues with FM 8 server should I continue down this road or should I be looking at something like exporting the fields and merging in Word. Or another option?

Any input would be greatly appreciated. Thank you.

[Wim Decorte]

Exporting and Merging is probably your best bet. You can also do this through XML & XSLT. Check out EZxslt.com for more.

[elanahy]

Thanks. It looks like the EZxslt product my be just what my client needs to simplify everything. I'm looking into it. Thanks for the info.