I used to work with Filemaker pro 6 and few months ago I started to use Filemaker Pro 8 Advanced, so every solution already made was upgrade, the thing was working well but suddenly with one script something wrong appered.

In some portal row some data was inserted there with my scripts changing between layouts and databases but right now filemaker is telling me that "can´t do it because the same record is been used in another window!!!"

I already checked file references and databases relations everything seems to be ok, I don´t know what else could be??? any ideas???

I´m kind of new with version 8 so I don´t know what is happening??? Help please

Thank you people.

Sincerely BluiSh :

Try inserted a Commit Record [] within your script. If you are entering data into the portal row, you lock the parent record until it is committed.

If that doesnt work and the prefered method, would be to go the layout of the actual child table occurence and create the new record there. Then it will not lock your parent record.

I have gotten that message at times. I just make sure that the data base to the data is being stored is close and everythings works after that.

Lionel

Edited March 7, 200817 yr by Guest