How to display data in dataGridView?

Question

C++ / C#

There is a database in Access, it contains tables Deliveries (code, product, supplier, delivery date, quantity) and Suppliers (code, name, address, telephone).
When displaying the Supply table in the dataGridView via OleDb, the supplier index is displayed in the "Supplier" field.
How can I make it display the name of the supplier with this index?

Answer 1

Figured it out myself.
You just need to correctly compose the SQL query.