Lookups allow data from another table to be linked to the main table.

In the example by linking a city to a state, the linked continent will also be shown in the list. This is because the state is a link to another table.

It will still be possible to search data for all columns shown by the linked table.

We create a countries by continent form with two text fields, one for states and one for continents.

Now we create another form for cities, with two fields one with city text and another with state and set it as lookup. At this point we will be asked which table to link it to and which field to display during entry.

The link to the table has been created and already in the list we can see the country. However, if we want to show the continent as well, we need to edit the list.

We go to the list view formatting tab, click on the country column pencil and remove the checkbox from "Keeps settings aligned with information from the same field in 'Form' tab." . By holding down CTRL we can select from the show field the columns we want to show. After doing save these will appear as normal columns, so it will be possible to reorder them, change their graphics, etc...