I have a lookup field that references another list and I'd like to be able to click on the one of the lookup results and then be taken to that item on the other list. This works fine in the standard All Items type views, but when in the form itself it opens the lookup list (to edit the field) instead of opening the linked item.
The problem goes away if i make the list classic, but the only issue I have there is that it is a fairly long list and the classic does not have a sticky header row.
Is there a way to have to click edit or something while in an item so that the user has to purposefully edit that field. NOTE: I have no problem with that being the rule on all the fields. Like a Read Only and Edit mode version of the form.