Hello Aparna -

Based on your description, it sounds like you might be missing the Loan__r.DisplayName__c in the “Search Fields” of the field on the Field Editor/Table Field that you are using.  You’ll also want to make sure that the field is defined in the page model itself.

Here’s the things to check

1) In the Page  Model, make sure you have Loan__c and Loan__r.DisplayName__c fields selected
2) In the Field itself, go to the “Search” properties tab and in the section called “Search Fields”, make sure you have added the Loan__r.DisplayName__c field along with any other fields that you want retrieved when the user searches.

Here’s why you need both:

1) Specifying the field on the Page Model will ensure that any time Skuid loads the data (e.g. page load, model requery, etc.) it grabs that field

2) Search Field - When a lookup is performed, Skuid is issuing a SOQL statement to retrieve data.  By default, it will only retrieve the Id and Name fields for the target SObject.  By adding additional fields in to this section, you instruct Skuid to obtain those as well.  After the user “selects” the lookup value, Skuid copies all those fields in to the target model.  This is likely why you are seeing a blank value after searching - because Skuid is only retrieving the Id & Name for the lookup field.

Hope this helps!

This worked – thank you!