Hey all
Been playing with InfoPath and SQL for about a month now and I seem to banging my head against a wall at the moment. I want to be able to submit my form to a SQL 2005 database, to a single table. The only way I can get that to happen at the moment is to use the "Database" template form which I'm having problems with on certain calculations.
There are a lot of posts here mentioning the ability to click "Enable submit for this connection" Does this tick box only appear when you select the "Database" form template? Or should I be able to do this in a standard "Blank" form?
I know there is an option to create a SQL Web service...but I'm struggling with that at the moment. Any "idiot proof" links to this would be appreciated.
Yet again thanks all in advanced. I think this is by far one of the best forums I've been on.
James