# How to set a single record as default value on a lookup query

**URL:** <https://www.five.org/t/how-to-set-a-single-record-as-default-value-on-a-lookup-query/721>\
**Category:** How do I?\
**Created:** [September 10, 2026, 10:54pm UTC](https://www.five.org/t/how-to-set-a-single-record-as-default-value-on-a-lookup-query/721 "2026-09-10T22:54:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![JeanXXIV](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/jeanxxiv/32/548_2.png) [@JeanXXIV](https://www.five.org/u/JeanXXIV)\
**Post date:** [September 10, 2026, 10:54pm UTC](https://www.five.org/t/how-to-set-a-single-record-as-default-value-on-a-lookup-query/721/1 "2026-09-10T22:54:53Z")

</div>

Hello,

On a form field, when using a \_LookupQuery with a query as a datasource, I noticed that when the result of the query is a single record, this record appears as the default value in the field. This is very practical.

Unfortunately, I deleted a field with this kind of lookup query that was working well and recreated it with, I think, the exact same components.

However, when the result of the query is a single record, it is not displayed as the default value like it used to. Do you have any idea what I should look at to bring back this “default value behavior”?

I reproduced this issue in the attached sample (this is the same sample as I provided in [Cannot create a Dependent Field with a Lookup on Dependent Tables - #22 by JeanXXIV](https://www.five.org/t/cannot-create-a-dependent-field-with-a-lookup-on-dependent-tables/617/22) ).

I have only one ‘Leader’, so when I create a new Task (in the Task2s menu), this leader should appear by default, but it does not.

Thanks for your help,  
Jean

[DependentField-on another page.fdf](https://www.five.org/uploads/short-url/yDxJWVNx7LO75QirIi2uPqqmr1A.fdf) (3.5 MB)

---

<div class="post-metadata">

**Author:** ![JeanXXIV](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/jeanxxiv/32/548_2.png) [@JeanXXIV](https://www.five.org/u/JeanXXIV)\
**Post date:** [September 12, 2026, 3:58pm UTC](https://www.five.org/t/how-to-set-a-single-record-as-default-value-on-a-lookup-query/721/2 "2026-09-12T15:58:41Z")

</div>

I found my problem! At the form level, the field must be mandatory. Display : Required if = true.

yes, this is quite logical 🙂

---

<div class="post-metadata">

**Author:** ![Jo-Anne](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/jo-anne/32/45_2.png) [@Jo-Anne](https://www.five.org/u/Jo-Anne)\
**Post date:** [September 14, 2026, 1:56am UTC](https://www.five.org/t/how-to-set-a-single-record-as-default-value-on-a-lookup-query/721/3 "2026-09-14T01:56:04Z")

</div>

Awesome, I was just about to look into this for you!

Kind regards,

Jo