I have three objects:DNR,DNROLI and LCROLI.
DNR and DNROLI is having master-detail relationship,DNR being master. DNR and DNROLI is having look up relationship with LCROLI.
On LCROLI page,I have a DNR look up field which will give list of all DNRs and a look up field OLI which will give list of DNROLIs associated with the DNR selected in DNR look up field.And the Lookup dialog will show following fields:DNROLI,DNR and Material number (a custom field on DNROLI).
Now ,the problem is when I select search by all fields (radio button) and provide material number to search,I am getting list of DNROLIs but When I am doing same with DNR,no results are returned.