Once you've created a Lookup Key for a table, you can use it to link records in one table to another.
Linking Existing Data Tables
To link a data table to another, navigate to the data table you want to link. In this example, we'll be connecting the School table to a table of Teacher Records.
Click on the Design tab.
This table already has several columns added, including the # years as a teacher, # years post-training, when the school year started, and where they are based. To pull in information about their school from the Schools table, click on (+) Add new column.
In the popup, you can specify what the column should be called. Click on the dropdown for Type and select Table. You can now click on the Table dropdown and select which data table you would like to connect.
Click on (+) Add Column.
Once you've added the column, DevResults will display all columns available from related tables, including those currently available and ones that are pending.
Once you've reviewed the pending changes, click on Save changes to link the tables.
You can now navigate to the Data tab to begin pulling adding data, including information stored in the "Schools" table.
Click on (+) Add new row.
You'll notice that adding information to the new row remains the same.
When adding information from the "Schools" table (column: School) to a row, you can click on the dropdown and select the School ID and Location you want to include in that specific column.
Click Save to add the new row.
If you want to display the School ID and Location separately, you can do so by clicking on the gear icon on the top right corner of the table.
In the list of columns below, you can choose to display any columns in the table you linked to this one. In our example, we can choose to display School: Urban/Rural, School: # classrooms, etc. If we want to remove the Lookup Key from the table, we can uncheck the box next to it. In our example, that would be the School column.
Once you've created a linked table, you can start populating indicators with this data.
Didn't answer your question? Please email us at firstname.lastname@example.org.