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