Datagrids and SQL

Hi,

Can anyone please assist with this problem?

I have a form in VB6 using an Acess Database.

I have two datagrids on the form - (Client and Partner). I want to populate
the second datagrid with the results of a selection on the first datagrid.
(i.e. User selects client on first datagrid and the details of the client's
partner are populated into the second datagrid).

My choice of datagrids etc. is for a specific purpose so I don't want to
change to text boxes etc.

I am especially interested in using SQL to populate the second datagrid
using a variable obtained from a field in the first datagrid.

Any advice/assistance would be great.

Thanks in advance.

Regards,

Schmalz