>Thanks again. So basically COUNT FOR +Trapping uniqueness of index is violated error should work. I have to think about it and discuss with my colleagues. I can make changes for the particular form, but it's better to make the changes on the class level.
I prefer the SELECT COUNT(*) on the buffered view/table because the count is retrieved into a cursor and leaves the source table as is with the record pointer on the same edited record.
Mark McCasland
Midlothian, TX USA