# SEARCH on the form seems to ignore fields populated via lookup

**URL:** <https://www.five.org/t/search-on-the-form-seems-to-ignore-fields-populated-via-lookup/385>\
**Category:** Support\
**Created:** [March 17, 2024, 10:35pm UTC](https://www.five.org/t/search-on-the-form-seems-to-ignore-fields-populated-via-lookup/385 "2024-03-17T22:35:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bernie](https://avatars.discourse-cdn.com/v4/letter/b/f19dbf/32.png) [@bernie](https://www.five.org/u/bernie)\
**Post date:** [March 17, 2024, 10:35pm UTC](https://www.five.org/t/search-on-the-form-seems-to-ignore-fields-populated-via-lookup/385/1 "2024-03-17T22:35:42Z")

</div>

The built-in SEARCH on top of the form seems to ignore in the List of records the values in fields populated via lookup to another table. In other words it doesn’t find the record despite the search values are there. Once a fields is populted is seems reasonable and useful that the SEARCH function should treat that field as any other.  
Thanks for your help

---

<div class="post-metadata">

**Author:** ![Pranoy](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/pranoy/32/281_2.png) [@Pranoy](https://www.five.org/u/Pranoy)\
**Post date:** [March 18, 2024, 11:55pm UTC](https://www.five.org/t/search-on-the-form-seems-to-ignore-fields-populated-via-lookup/385/2 "2024-03-18T23:55:39Z")

</div>

Hi @bernie

The search function works as long as those lookup fields are included in the list, For example, I have an app here with two lookups referencing two different tables:

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/five/original/1X/661256b37950fb1dd6970b4d97b9abbdb237130f.png)

and you can see the search function works for this case:

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/five/original/1X/7ae985b75720b2ec556dc8b2ae12b8cf63bc936a.png)

You need to include the items in the list displayed below the search bar in your form. You can do this by:

1. Navigation to ‘ **Visuals** ’ → ‘ **Forms** ’
2. Here click on the desired form, and then select ‘ **Pages** ’ and then double-click on ‘ **General** ’
3. Now you are inside the general page of your form, from here you can click on the ' **Fields** tab which will reveal all the fields that are displayed on your form
4. If you click on any field here it will open up its details and from here you can simply select the ‘ **Include In List** ’ option  
 ![image](https://canada1.discourse-cdn.com/flex030/uploads/five/original/1X/714ee9eca53aded2eced750c30c7b1157d4e8b67.png)

This will display the items in your form list and the search bar should be able to pick it up.

Let me know if this works or not for you

---

<div class="post-metadata">

**Author:** ![bernie](https://avatars.discourse-cdn.com/v4/letter/b/f19dbf/32.png) [@bernie](https://www.five.org/u/bernie)\
**Post date:** [March 19, 2024, 3:42pm UTC](https://www.five.org/t/search-on-the-form-seems-to-ignore-fields-populated-via-lookup/385/3 "2024-03-19T15:42:13Z")

</div>

thank you - I believe I got it