ADODC, DataGrid Query

[ManicMark]

Hi All,

I am new to this ADO and DataGrid procedure but have created a query to populate the DataGrid on the form, this I found easy but now I wish to do the same on another form but this one is not so simple, I wish to retrieve data from two separate tables (joined by 1 to Many relationship) I have one table Product and the other Sold. I have noticed that the DatGrid is connected to the adodc which is connected to the database and the product form.

How, using the adodc, DataGrids and SQL do I get the info from two tables.

Thanking You

Regards

M

 

[Genotix]

Don't use ADODC try using ADODB

Linux IS userfriendly.
It's only very selective about who it's friends are.

 

[Genotix]

How, using the adodc, DataGrids and SQL do I get the info from two tables.

By the way, have you tried a JOIN in your SQL query?
Don't know if it works but my guess is it should.

Linux IS userfriendly.
It's only very selective about who it's friends are.