Data validation

Hi ,

In an Oracle Applications form I am trying to modify  field1 and field 2 , so that when user enters a value 'XYZ' in field1 to query the record from databse table , the process must search for value 'XYZ' in the columns field1 and field2 as well.

If it finds any record in database table with field1 ='XYZ' or field="XYZ'  the record must be displayed.

Currently  the form is just searching the field1 column. Can anyone please suggest how to achieve this.

Thanks,

S