InfoPath Dev

Hi All,

   I have an InfoPath Application, which uses a Master/Detail controls and a backend Sql Server database to store information. The issue I am having with these controls is that, when a user has selected a row midway on the Master repeating table and then he/she modifies a data field on the details section and hits the submit button, the Master repeating table row goes back to the first row after saving all the changes. This action then forces the user go back to find out which row he/she was working on last. Is there a way to modify the submit button so that after hitting it, the data is saved and gets the user back to the last master repeating table row that he/she was working  on and not having them search for that last row where they were before. Any suggestions on how to resolve this issue will be greatly appreciated.

Hi there.

I do not believe there is with the database type form you have. On submit it saves all data and then requeries the data again so you have effectively refreshed the data.

With web services you could save the data without these default, hard coded processes.

Thanks for this information...now I can stop beating my head against a wall, trying to come up with a soultion...

If you would like to see how to add web services to your SQL server and give yourself a lot more possibilities and functionality send me an email and I can show you some examples.