InfoPath Dev

I have a similar situation to some I have read on here, but no one has seemed to address the issue.

I have a single inforpath form I make available from a web link. I pass in the query string the id of a single record in a table which contains the form data. The form opens and I connect to a web service to get the record and populate the form. I have a few users who are working on a set of records and different people need to set certain fields. There are also a few people who may make changes to any of the fields. The problem is when two people open the form they are using data at that point in time. The first saves their changes and then when the second person saves they will overwrite the first person's changes. Locking the record will introduce delays and timeouts to anyone else who may just be reading the data. I am thinking about adding some type of locking column in the DB but introduces other problems. It would be really nice to have in infopath the same type of shared document usage that Word has where it notifies the next person that someone has it open and do they want to open a read-only copy or wait and be notified.

Steve

hi steveb,

if two persons open the same infopath form at the same time, the first one to save will save it properly, but when next one tries to save it, he will be given a warning dialog box that the data has changed and does he want to overwrite it (similar warning, i dont remember the exact words). so onus is on second person to save the previous changes.

No warning is given. How does the form know that someone already saved one? It doesn't.

The save is done through a web service function call.

A warning at the point of save is not a good solution because someone may have been working on the form for a long time and then they find they can't save because the data has changed. So then they have to reload and start over? They are not going to accept that.