Hello everyone,
What im trying to do is have a form that will check for a value in a TxtBox across a network.
I have a form that when creating a new record it automatically creates a new record number, but the database is running on many computers at the same time and if they all go to create a new record they will all start with the same number, is there anyway to have the database look at all the open forms to check and see if a form already has the starting value and if so then go to the next number (which would be an increment of 1)
For example if computer A, B, C all have the form open.
If A says record 1 then B will change to 2 and C will then change to 3.
Im not even sure if this is possible. I have been doing a bunch of research on this but cant seem to find any solution. Only thing i can find is after you save which does not really help me, because im am trying to avoid the possiblitity if two people are creating the same record and save at the exact same time it wont let them both create the same record. Which currently my program does. Of course if they wait like 1 sec apart it will catch it in the Table but i would like to catch it before that.
Thanks in advance for any info or help on this :D