A select list is a type of column where you create a pre-defined check list of entries allowed in the column. It is not a Table join, since the list is not in a separate table, but it is convenient to include it in this list.
Check tables can be implemented using the Select List column type. In this case the check values are stored in the Main Table.
Each column that is defined as a select column stores it values on the column options are.
If needed, the select values used for a select column can be moved to a standalone table.
There are two basic ways to link tables together
For me the way to determine whether to use a Lookup column, or t build a formula using filter, is whether the tables already contain data.
If Main table is empty, and will be filled as the doc is used, then a Lookup column typically makes sense.
If you have two tables filled with data, that has a common field that you can use to join them together, then the filter() formula works well. (I often download data of sales, customers and products, which needs to be linked together to provide meaningful analysis.)
NOTE: The choice you make above, has an impact on how your data is explained in group, detail and table views. Examples are included of each view in the examples below, where applicable.
Create a lookup column in your table, and link that to another table. There are some examples in the following section. Implementation range from a simple single column Lookup table, to complex multi-table, filtered lookups
Filter() in a formula column
In a formula column, create a filter to select data from the source table. Because this is a formula column, it is not possible to manually enter data into this column.
In its most simple form, you will have a one to one relationship between two tables, and filter the data from the source tables.
You can also have a complicated filter condition, using several columns, to filter data from a source table, where the filter could select more than one record. Then you need to choose do you want to see all of the values, or just the first(). Some other manipulations are also possible, like sum() or average() for numerical columns, and count() for all columns.
Examples follows below, from simple to not so simple.