how to create tables with linked coulmns in sql server : i'm trying to create a database for a simple C# application using sql server.
i'm new to this

this is what I had planned

    Clients: Client_ID, Client_Name, Client_Status
    Employees: Emp_ID, Emp_Name, Emp_Role
    Jobs: Job_ID, Job_Date, Client_ID, Employee_ID, Hours_Spent

how do i make the "Client_ID, Employee_ID" columns in table Jobs linked or connected the original ones in the tables Clients and Employees? do I do it from SQL server management or from the c# code?

