>It is possible to have two base-table blocks in a form without needing to open a separate form in the same session. And there are ways to avoid seeing the FRM-40405 message without opening a separate form.
I have created a form with two blocks (Database block). Those two block is based on two master table . And there is a mapping table for those two block. user can open those two block from two menu option .
When user is doing that user is opening the same form in two different session.(And I have to allow that. I cann't even make it one session because if it is in one session user will get the message (FRM-40405 "No changes to save") if he make any change in one form and don't make any change in other form).>
one second user delete one of the department that is associates with that employeeIn that situation the 1st user will get a FK error message (Department doesn't exist) when trying to save the changes in the form.