---
sourceDocument: Australia Build or modify applications
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/pt-BR/application-development

 Release :

    - australia

ft:locale :

    - pt-BR

ft:publication_title :

    - Australia Build or modify applications

ft:clusterId :

    - cadev

bundleId :

    - cadev

workflow :

    - Development, Data, and Analytics


---

# Share data between tables

# Share data between tables {#ariaid-title1}

* Versão de lançamento: Australia
* 
* Atualizado 12 de mar. de 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 min. de leitura

Share data between tables to avoid data duplication.

## Antes de Iniciar

Role required: admin, sn_app_eng_studio.user, or delegated developer

Select the following link to download the material needed for this step in the app creation tutorial.

[App creation tutorial airport spreadsheet](https://downloads.docs.servicenow.com/resource/enus/tutorial/app-tutorial-airports.xlsx)

## Por Que e Quando Desempenhar Esta Tarefa

The final phase in building the data model for the employee travel request application is to link the travel request table to a separate table that stores airport data. Doing so enables employees to choose which airports they
want to use when they complete employee travel requests.  

|-|-|-|
| Phase 1 | ![Completed icon]() | [Create a data table](https://servicenow-prod.fluidtopics.net/KD6vcfYS7ZDMA35hDOjFaQ "Create a table to store the data for your application.") |
| Phase 2 | ![Completed icon]() | [Configure a data table](https://servicenow-prod.fluidtopics.net/GOdd3WL3dkP86C_FTAlSyQ "Configure a table to capture the necessary data for your application.") |
| Phase 3 | ![In progress icon]() | [Share data between tables](https://servicenow-prod.fluidtopics.net/_0OGqHra7QtbJkgHTgGKyg "Share data between tables to avoid data duplication.") |
[ ]

{#app-tutorial-share-data__table_or3_vg3_3db}

Storing data in multiple tables enables you to keep your data organized and modular. When you want to share data between tables you can create reference fields, which pull records from one table into another without
duplicating the data.

Download the airport spreadsheet and follow along with the tutorial to create references fields between the employee travel request and airport tables.

{#app-tutorial-share-data__table_m31_zyf_ncc__entry__2}

| Timestamp | Section |
|-|-|
| 0:03 | Create a table to store the data that you want to reference. |
| 0:26 | Configure the table. |
| 1:05 | Open your existing table. |
| 1:13 | Add new fields to the existing table. |
| 1:19 | Set the field type to Reference and select the table that you want to pull data from. |
| 1:36 | Save your changes. |
| 1:38 | Add the new reference fields to your table in Form view. |
| 1:59 | Customize the form layout. |
| 2:10 | Save your changes. |
[Tabela 1. Video sections]

{#app-tutorial-share-data__table_m31_zyf_ncc}

## Procedimento

1. Create a new table to store airport information.  
   In our tutorial, we create a new table from a spreadsheet that stores airport information. To follow along with the tutorial, [download the airport spreadsheet](https://downloads.docs.servicenow.com/resource/enus/tutorial/app-tutorial-airports.xlsx). Then use the procedures in [Import a spreadsheet](https://servicenow-prod.fluidtopics.net/OGkZxX3ZHAnX3xmtM_B4OA "Upload a Microsoft Excel spreadsheet and use it to create your application data model.") and [Create new table from spreadsheet import](https://servicenow-prod.fluidtopics.net/RbTZuNPyed1nKp6U01UJ7g "Create new tables directly from a Microsoft Excel spreadsheet import.") to create a new table from the airport spreadsheet.
2. Customize the table so that it displays the information that you want to reference.
   1. Select the airport table from your application dashboard in App Engine Studio.
   2. On the table landing page, select the More actions icon (![More actions icon]()) next to Data in the top ribbon, then select Fields.  
   3. On the Fields page, in the Name field, toggle on the Display switch (![Toggle on.]()) to enable other tables to reference airport names.  
      Importante:  
      You can select only one field to be referenced by other tables. If you attempt to select multiple fields, Table Builder keeps only one of your selections when you save your changes.
   4. Select Save.
   {#app-tutorial-share-data__substeps_ovr_5ln_ncc}
3. Navigate to your application dashboard in App Engine Studio.
4. Select the employee travel request table, where you'll create the reference fields that pull data from the airport table.
5. On the table landing page, select the More actions icon (![More actions icon]()) next to Data, then select Fields.
6. Create the reference fields.  
   In our tutorial, we create two reference fields to collect airport choices for employee travel requests.
   1. On the Fields page, select + Add a field in the table.
   2. In the Column label field, enter <kbd class="ph userinput">Travel From</kbd>.  
      The Column name field auto-populates based on the label that you entered.
   3. In the Type column, select Reference, then select the airport table from the list.  
      In our tutorial, we create another reference field to capture where the employee is traveling to. We label this field <kbd class="ph userinput">Travel To</kbd>.
   {#app-tutorial-share-data__substeps_y51_d55_gdc}
7. Select Save.
8. Add the reference fields to the form view of the table.
   1. Select Forms in the top ribbon.
   2. Enter the label of the reference field in the Search bar.  
      In our tutorial, the reference fields are labeled <kbd class="ph userinput">Travel From</kbd> and <kbd class="ph userinput">Travel To</kbd>.  
   3. Drag the reference fields from the Add form elements panel to the Default view panel.
   {#app-tutorial-share-data__substeps_ovm_mt5_gdc}
9. **Opcional:** Repeat the process in steps 6--8 to add as many reference fields as you need.
10. Select Save.

## Resultado

The data model for the employee travel request application is complete.

## O que Fazer Depois

Continue building the employee travel request application by proceeding to the next step in the app creation tutorial: [Creating user experiences](https://servicenow-prod.fluidtopics.net/nW87z4W_QsnGer36cI0J6w "Create the user experiences for your application. Learn about experiences in App Engine Studio and how we build the user experience for the employee travel request application.").