well, I have had this isuue long before but, thought of sharing the issue. I have a key column setup not as autonumber but as a "number" like this 2002xxx, where xxx is the number that changes when user inputs new set of data. Problem arises when 2 users simultaneously enter SAME 2002xxx number adding new data. in this case
I receive two rows of data with the same ID for example 2002123 John Doe Manager Ok
2002123 Jane Doe subordinate Ok did any one had same problem?
