Loading

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

Christopher Hankwembo

8y833

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Packiaraj Santhiyagu8y ago
Hi,

In your script your are using PK and FK, create join query based on the keys.
Uttam Chaturvedi8y ago
Please have look in below links. It may be useful for you

https://www.the-art-of-web.com/sql/lookup-table/

https://gist.github.com/esfand/9444313