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