SQL Server and Status update

[Kalpana]

Hi All

Can anyone tell me if this is possible please?

We have an infopath form that has a main connection to a sql server
database. I have table called Clients and another table called Projects.
These 2 tables are related. As I have new clients/projects I fill up the form
and submit. A row is created in each of the table. Everything works fine.

Now I have a requirement - I need to have a new form - hence new infopath
form library in sharepoint - This new form will have 2 dropdown controls -
one a list of all the clients in the client table and the other a list of all
the projects in the Projects table. I will have 2 buttons - one to close a
client and the other to close a project - this merely set a status on the
database column to "Closed".

I tried various ways but fail to succeed. Is this even possible.

Any help or directions is greatly appreciated.

Thanks
Kalpana

 

[Clay Fox]

You would need a database form with the same table structure as your original
since you want to be able to submit data back to the sql tables. You can
probably make a copy of yours and just rip out what you do not need.
Because of InfoPath's default limitations, you have to query everything
again even to update a couple fields. The other option is web services which
is really the best solution.
You can get an installable package of web services at http://www.qdabra.com

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com