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)