Datagrids and SQL

Question posted by: Schmalz (Guest) on July 22nd, 2007 04:45 PM

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

Not the answer you were looking for? Post your question . . .
189,814 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).