Hi all
I have a table that when a new record is added, the key must be the previous record key + 1
I am having probelms when 2 or more users add new records at the same time. Is ther a way to create a trigger that will populate the key fiedl for the new record with the key of the last record + 1
thanks
jsn
I have a table that when a new record is added, the key must be the previous record key + 1
I am having probelms when 2 or more users add new records at the same time. Is ther a way to create a trigger that will populate the key fiedl for the new record with the key of the last record + 1
thanks
jsn