I would like to set up a button on my layout that will push the data in that layout to quickbooks. Is the best way to go about this is to set up ODBC connection and use SQL statements?
I believe Productive Computing has a plugin for bi-directional updating between FM and QB. Google them as it should not be hard to find.
Ok, but just so everyone is away, I'm not looking for bi-directional data transferring between QB and FM. Just pushing data to QB from FM.
You will need the read/write version of QODBC to do that - which is the same price as Productive Computing plugin, but that has example scripts ready of you to use... rather than leaving you on your own..
Retrieving data ...