Managing Increments

Hi there,

I have a program in accounting that is used by many clients and users at the same time in a network. Many modules have a reference no. like in the receipt that increments upon saving, it also Checks whether that reference no. is already in used.

However problem arises when the many users use the same module at the same time. My question is How do you manage incremental values on each client's PC? Their local system somehow competes for the next incremental no.

I will appreciate any ideas and help.

Thank you!