Hey all,

I'd like my users to be able to click on a record in one Datagrid, and have it display a different recordset in the second Datagrid using a query based on one of the fields in the record.

I tried doing this with two Adodc's, but when I put the app on other people's machines, I got an Adodc error, which I'm assuming is because I have multiple Adodc's connected to the same database. If I'm right (tell me if I'm not!) then I have to do this with one Adodc. How can I do this and still keep the original data in the first Datagrid?

Basically, I need to populate a Datagrid, disconnect from the Adodc it's attached to, and then "freeze" it's contents so I can use the Adodc to populate the second grid.

Whew!!!