I have a formset. The first form contains a grid with a summary of all the invoice. The second form contains a master-detail entry form for the invoice.The detail is a grid taking data from a parameterized view. When the user clicks on add button on the first form, I will unhide the entry form. Upon saving, I will hide the entry form and show the summary. I use default data session.

Sometimes, when I try to add a new invoice, I get the error 'file is in use by another user'. I am on standalone PC. Can someone tell me why I get this error?

My guess is the grid pointer position somehow gets out of synchronization with the parameterized view record pointer. After weeks of suffering, I came out with this! Believe it or not, I just put a messagebox prompt before my 'begin transaction' and it seems to work!

I hope someone can give me some clues on why this thing happen so that I can really solve this problem.

Thank you.