A very powerful aspect of Stacker is the ability to create links between tables, to enable you to share data across tables.
How to create links between tables in Stacker
- Go to the table that you would like to link to another table.
- Click Manage fields and data
This will open the Fields Settings for your table. Here's what to do next:
- Click Fields
- Click Add field and select Link to another record
- Enter a field name (we suggest choosing a name that accurately reflects the information the data is linking, e.g. 'Link to Client')
- Choose which table you want to link to
- Select which fields you want to link. Please note: in order for the linking to work, the values in those fields must match exactly.
- Once saved, you will see the new field in the field list.The link is also visible in the table you've linked to - though it is not editable from this side.
