View problem

hiwe are creating a form(contractmanager) that will be populated with company name,product name and associated contract manager name. we are also creating views CM by Company(company name,Cm name and lastmodifieddate) and CM by product(product name,Cm name and lastmodifieddate) to do the look up of the information that is entered in the form.

the first look up for CM would be by company name.

if not there, then the next look up for CM would be by Product name.

if not there, then put fields kumar name.

how to write view condition for above rule

Subject: RE: view problem

Your question doesn’t make sense. You have the contractmanager form when the user is editing. There are three fields on it. They will enter values in each of the fields. What part of this process requires a search through all the views for a value without knowing whether the value is a company name or product name or what?

What language did you want to use? What will you do with the results? What does “then put fields kumar name” mean?