In a forms 10 application i have a DATABLOCK that has a select with a join with 3 tables. In this datablock i also update one of the tables in that select by setting the DML TARGET to the table's name.
I want to do the same thing in DOTNET. I want a gridview that gives me the output of the join and when i do an update, it only updates one table.
I know that i can define the update statements but when i put in the SELECT statement the join query, the update no longer works.