Form built to Retrieve - Can this be changed to submit to a SQL Database?

Medwaylass — Wed, 22 Oct 2014 08:07:53 GMT

Hi all

I have a form that was originally intended to just provide information to our users dependant on the outcomes that are selected via a series of drop down lists (content retrieved from SQL tables), and was therefore built on a blank template.

It has now been requested that we track the usage of this form, so ideally I wish to obtain the users login details, which I can do via way of SQL table/triggers etc., but in order to be able to action this, I need to be able to change the main connection in the form to submit to a SQL database.

I have scoured the internet, but seem to be unable to come up with a solution. I really do not want to have to rebuild the form as it is rather complex!

Would really appreciate any help :)

Many thanks in advance

Data Connections

Form built to Retrieve - Can this be changed to submit to a SQL Database?