Hi,
What I have:
1. A database.
My need:
1. Implement a form service solution.
I want to:
1. have the database as back-end
2. InfoPath 2007 form as front end
3. Publish the forms to sharepoint so that I can use workflows for approvals
What I did:
1. Wrote a web service in 2008 that would get and put data in the database.
2. Desinged a form based on that web service.
3. I also desinged a blank form and try to attach the web service submit method.
Problem:
1. InfoPath form seems to put "require" tag infront of all data types except string data type (this was not an issue in what I did # 3)
2. I cannot get way around for dates and master table ID (primary key, identity)
3. When submit button is clicked it say, successfully submitted but there is no data in database. (in both cases what I did #2 & #3)
4. Is there any other better way of implementing this?
Any suggestion or help is appreciated.
Thank you,
