i am using unbound dbgrid to allow user to add, edit or delete any data about the purchase order details.

the problem is the item ID entered should not be duplicated since it is a unique key in the database.

i got problem when trying to write the code to check the row entries in the Item ID column each time the user enter that data.

can someone help ?

thanks