Connecting Tech Pros Worldwide Help | Site Map

Datagrids and SQL

  #1  
Old July 22nd, 2007, 05:45 PM
Schmalz
Guest
 
Posts: n/a
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


Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating related records in SQL Server, C#, Visual Studio .Net 2k3 kolalakitty answers 0 October 20th, 2006 09:25 PM
Multiple Datagrids to scroll through answers 4 November 21st, 2005 08:32 PM
Populate 2 or more datagrids from one OleDBCommand Simon Harris answers 1 November 19th, 2005 04:25 AM
Filling two datagrids from two SELECTS in one DataSet DC Gringo answers 2 November 18th, 2005 05:47 AM