Let think how it can be done in practice
1) You can always place lookup on the record form
2) editing "select * from multiple tables" will not work,
not because we do not want to help you,
but because only OleDB connections sort of work (and fail everyday)
and the rest MySQL, Oracle, ETC does not support it
3 ) Adding lookup to the grid.
For example we have City_ID field in the table customer and we would like to show City_Name instead
We did try to implement it in the past
Very slow, next to useless.
Problems with filtering data and sorting and result users constantly complaining
We would need to create an editor for grid which will allow the user to add edit fields and define lookups
4) Since it is not possible to edit the data directly, we can try to generate sql on the fly.
Eg for every action create sql for delete insert and update and execute it
since it has to work with every database we support, we would need to support every possible datatype as well
We would need to create an editor for it as well
after every action we would need refresh the data
5) if you work with oracle you can use instead of triggers
The conclusion due to the complexity of the task at the moment we are not planning to implement it
