I have a problem regarding
DataGridView. I need to show a
Client_Name instead of
This is the
Product table and it has a relationship with the
I'm using Access DB and DataSet.
In order to avoid having to do multiple queries to get the client name for each product you should include on your query an inner join to Clients table and return the client name along with the product data.
SELECT pro.*, cli.[Name] as ClientName FROM Products pro INNER JOIN Clients cli ON cli.Id = pro.ClientId
We could help more if you specify your data access strategy.