I Have Table Wich Has Around 45000 Record's, I Have Form And Subform Wich Linked By [Reciept ID], What Is Going Is:
* The [Reciept ID] Is AutoIncremening By Dmax(......).
* When Both Of User Opening Form The Problem Is Starting..
- Both Of Them Will Have The Same [Reciept ID],,,,,((
- The Subform Will Has The Same [Reciept ID],,,,,((
* Now The Winner Who Will Be Faster To Finish His Data Entry.
* And The Next Who Will Drive Me To Hell.
- I Have To Delete The All Record's In SubForm And Delete All The Data In The Form Then Give Anew [Reciept ID],,,,,, Etc.
The Next More Funy Is If The Winner Will Be More Fast And Open The Form To Add A New Record ............................... Waooooooo.
Please Please Any Help Will Be Appreciated.
What Is The Way To Avoide This Conflict As Long As The Record Is Not Saving Untill You Finish All The Entry?
Thanx In Advance
* The [Reciept ID] Is AutoIncremening By Dmax(......).
* When Both Of User Opening Form The Problem Is Starting..
- Both Of Them Will Have The Same [Reciept ID],,,,,((
- The Subform Will Has The Same [Reciept ID],,,,,((
* Now The Winner Who Will Be Faster To Finish His Data Entry.
* And The Next Who Will Drive Me To Hell.
- I Have To Delete The All Record's In SubForm And Delete All The Data In The Form Then Give Anew [Reciept ID],,,,,, Etc.
The Next More Funy Is If The Winner Will Be More Fast And Open The Form To Add A New Record ............................... Waooooooo.
Please Please Any Help Will Be Appreciated.
What Is The Way To Avoide This Conflict As Long As The Record Is Not Saving Untill You Finish All The Entry?
Thanx In Advance