Don't want to delete from secondary table

I use a TADOQuery with...
Select * from LoanView Where OrdNo=:OrdNo

The LoanView was created like this...
Create View LoanView
AS

Select OrdNo,LoanSort,Lender,Name,LoanAmount,LoanNumber,MonthlyPI,MortInsCaseNumber,
InterestRate,LoanPolicyLiability,IsPrimary,IsSecondary
>From Loans
Left Outer Join Agent on AgentNum=Lender


I use the view with the join because I want to show the Name from the Agent table in my grid.


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)?


Thanks,

Jon
.