I use a temporary table to store values from the form and when the form closes, transfer temp data to another table and clear the temp table. This works fine if one user working on it. If multiple users working on the same front end, then throws a tricky scenario.
How to solve this scenario where front end shared by multiple users and temp table required for some purpose. I am not an expert but a power user.
How to solve this scenario where front end shared by multiple users and temp table required for some purpose. I am not an expert but a power user.