Hi Chris,
What I've done is add a processing column to the orders table,
and when someone is editing the order the client app sets that order's processing to true,
and when the user exits the editor, the client app sets processing back to false.
If someone tries to launch the editor on an order that is being edited a Message pops up, to try again later.
I have added an override mechanism in case any orders get stuck on processing due to connection or app failure.
What do you think?
I know its not the safest and most efficient, but if only 10 users are using the system, this should suffice.
I only have about 6 months exp with
Java and about 2 months exp with SQL.