I have a type 3 form (multiple occurrances). When I finish adding the record on the first occurrance and move to the second occurrance I would like to update the record at that time. Right now, I have to fill all occurrances or hit the save button to save the record. I believe I want to use the execute(update.db) function, but I am not sure where I need to put it in my program. Can anyone help?

I remember doing such things had created different problems for me (like error 206 , transaction is on etc) . The reason for this was that I needed to generate a running serial number which works perfectly in all kinds of scenario.

If you also have the same requirement then I would suggest you use on.main.table and do.all.occ function to accomplish this task.

Good luck.

I faced a similar problem recently that I was getting either error 206 or transaction is still on and the only way to get around it if ur updating multilple occurences is to call do.all.occ() in before.rewrite section of main.table.io....just thought to share with all those whose face similar problem.