BI Tutorials - How To Define Foreign Keys

DataLynx BI Tutorials

Define Foreign Keys

Introduction

Foreign Keys are basically the glue that adheres database table together. A Foreign Key is a field in one table that refers to a Primary Key in another table, allowing them to be connected. For example, if we have a cars list in table "Cars", the Mercedes with ID "2" is owned by employee "5" (Foreign Key), and John Doe happens to have ID "5" (Primary Key) in "Employees" table. Now we can say that John Doe owns the Mercedes.

Creating Primary Key / Foreign Key Links

create primary key foreign key link

This connection gives us the ability to join 2 or more tables into 1 table, which gives us more flexibility in creating meaningful charts.

The system only shows relevant fields in the drop down. For foreign keys, they have to be integers and not Primary. Primary keys have to be identified as Primary Keys in your original database.

About DataLynx BI

DataLynx BI is a Business Intelligence and Data Analytics SaaS. It connects to multiple databases to create a central data management solution. Claim your 14 days trial period