I use a TADOQuery with...
Select * from LoanView Where OrdNo=:OrdNo
The LoanView was created like this...
Create View LoanView
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)?