want to implement primary key on forms field
Hello, experts,
i have a form with single base table deptno.
dept_name and deptno . deptno is primary key in database table.
when i enter records, it prevent to insert duplicate value in deptno text box when i insert or update .
form this i create a block with base table dept. block's property Enforce Primary key is yes.
then i set deptno fields primary key property to yes.
when i enter duplicate records then save , it prevent to insert but i want the following:
i run the form, when i enter first record, if it exist in table then prevent to insert. also after inserting first record,
if i again insert same deptno in next record it should also prevent.
please help me out.
thanks
Yash