Re: Don't want to delete from secondary table

Thank you very much. Unfortunately it didn't work. Finally I did it brute-force. In OnBeforeDelete method I delete the
record in the underlying main table and abort the original delete.

Jon

--- Brian Bushay TeamB wrote on 05/25/2005 21:13:35 :
>>
>>I have a TwwDBGrid with a TDBNavigator using a DataSource using the query.
>>
>>If I click the - on the navigator, to delete a record, it tries to delete the Agent record as well as the Loana record.
>>
>>How can I make this only delete the record in the main underlying table (Loans)?
>
>set the Unique Table property
>
> ADODataSet.Properties['Unique Table'].Value:='Loans';
>This property needs to be set after the dataset has opened
>--
>Brian Bushay (TeamB)
>Bbushay@xxxxxxxxx
.