How to create a Lookup in a related table in SQl Server 2016

Jun 25 2018 1:53 AM
Dear Experts;
 
 
Help me with a way how to create a lookup in a related table like below:
 
Customer Table
 -CustomerID (pk)
- Customer Name
- Address
- City
- Country
 
Invoice Table
 -Invoice ID
-Customer ID (fk)
-Sales man
- Ship Date
 
 I'm currently using Visual Studio 2016 with C# programming laguange under windows form application.
 
I want to use also on the datagridview either through direct binding or code 
 
 
Regards
 
Chris 
 

Answers (2)