DataLynx Logo

DataLynx BI Tutorials

Define Foreign Keys


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.

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