Forms 6i/Oracle 10g: In detail block, if field is null then enable/disable button

User_1XBL6

Hi Guys

I am facing an issue in master/detail form.

Detail block purchase_Detail (productid,desc,uom,orderqty,unitprice,totalvalue)

During entry in detail block where productid is selected through LOV and set required is yes in field property. if user is press enter key, the cursor move to new row and stay at productid because of required Yes...

I would like that to create a button "clearrecord", it is enable when productid is null to clear record otherwise disable button ... it should be workable for new entry as well as execute query case.. see below screen for understanding

Waiting for your kind response to resolve this issue ....

Javed Akram