Deleting PART of a record from an INNERJOIN query in a DATAGRID

[Amanda V]

Hi Everybody,

I have a DataGrid that is populated by an ADODC data object. I use an
SQL query to grab all the fields from a joined table. I use innerjoin.

I store general device data in one table (Gen_Device_Data), and that
table has a 1 to many relationship with all of the test data
(Test_Data) for each device (each device is tested several times, and
there are several devices tested for each set of Gen_Device_Data
stored.

ie.

Gen_Device_Data has PartNumber and Manufacturer

Test_Data has PowerMeas, Voltage, Temperature, LightSource

When I use the delete function with the DataGrid, and try to let a user
completely delete a record from the recordset, it deletes the entry
from Gen_Device_Data and therefore all of the relationships between
still remianing devices in Test_Data lose their reference.

Is there a way in VB code to have the delete function in the DataGrid,
only affect the fileds of a certain table in the recordset (ie I want
the user to delete the record in the recordset from the DataGrid, but I
only want to delete the record from the Test_Data table and not it's
corresponding Gen_Device_Data record)?

Any suggestions would be great!

AV