Hi,

I have one question for you, if you can answer and refer resource it will be great help.

I have a scenario where i need to create a appointment slot and a serial no for each slot memberwise.

ex:

Member Id |App Slot #

1|1

1|2

2|1

2|2

1|3

what im doing is take the Max slot number,increamenting it and insert it memberwise. but the problem is concurrent user can create a slot when i take the max slot after that if any other user insert the slot the value that im working with is no more valid, how to over come this problem

Thanks & Regards,

Sameer