I have the need to change the field that is clicked on to specify a particular record on the Product lookup layout. I can create a custom page if need be but I am curious if there is a way to use the HYPERLINK function in a formula to dynamically create a link that can be clicked on instead of the Name field. I understand that I will not be able to remove the Name field from the page layout - I will have to switch it to a Auto-Number field before it can be removed.
I am curious whether or not anyone else has come across something like this. I was unable to find anything on it already.
Looking at the above picture - I am trying to click on the Product Code custom field in the lookup dialogue box instead of having to click on the Product Number field in order to populate the Product Lookup field on the Page where the lookup icon was clicked. The page behind is a custom visualforce page so I do have control over what happens if that opens up any possibilities to me.
I have created an entirely new lookup field module with a custom visualforce page in order to resolve the issue I am facing - which is working for our use case. I am now just generally curious if this is possible going forward.