# How to display multiple fields from a related record

**URL:** <https://forum.kintone.dev/t/how-to-display-multiple-fields-from-a-related-record/205>\
**Category:** General\
**Created:** [October 4, 2021, 1:36pm UTC](https://forum.kintone.dev/t/how-to-display-multiple-fields-from-a-related-record/205 "2021-10-04T13:36:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![legacy\_user](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/legacy_user/32/25_2.png) [@legacy\_user](https://forum.kintone.dev/u/legacy_user)\
**Post date:** [October 4, 2021, 1:36pm UTC](https://forum.kintone.dev/t/how-to-display-multiple-fields-from-a-related-record/205/1 "2021-10-04T13:36:18Z")

</div>

I have a lookup field that finds a related record and displays the chosen field.&nbsp; How do I display other fields from the selected record.

**Example:**  
A Form’s lookup field lets me search for a person by first name.&nbsp;  
How do I also display his last name on the form?

Thanks!  
Jeff

---

<div class="post-metadata">

**Author:** ![legacy\_user](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/legacy_user/32/25_2.png) [@legacy\_user](https://forum.kintone.dev/u/legacy_user)\
**Post date:** [October 4, 2021, 3:37pm UTC](https://forum.kintone.dev/t/how-to-display-multiple-fields-from-a-related-record/205/2 "2021-10-04T15:37:09Z")

</div>

**Answer** :

1. Create a new field of the appropriate type (e.g. Number, Text, Time, etc) and give it a name
2. Edit the Lookup field’s settings and add a “field Mapping” that refers to the field created above.

**Example** :

1. Create a text field called “Last Name”
2. Create a lookup field called “Lookup Person” and edit it’s settings
3. Select your Person table as the Datasource App
4. Select the First Name field as the key.&nbsp; This is the field that you’re searching on.
5. Under field mappings, select the “Last Name” field created above and map it to your [person]Last Name.&nbsp; This field becomes read-only and displays the person’s last name

&nbsp;

&nbsp;

---

<div class="post-metadata">

**Author:** ![legacy\_user](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/legacy_user/32/25_2.png) [@legacy\_user](https://forum.kintone.dev/u/legacy_user)\
**Post date:** [October 5, 2021, 10:33pm UTC](https://forum.kintone.dev/t/how-to-display-multiple-fields-from-a-related-record/205/3 "2021-10-05T22:33:10Z")

</div>

Hello Jeff,

That should do it. If anyone is looking for more information about a lookup field, here’s the page:

Kintone - Setting Lookup

[https://get.kintone.help/k/en/user/app\_settings/form/lookup/set\_lookup.html](https://get.kintone.help/k/en/user/app_settings/form/lookup/set_lookup.html)