SQL update on joined tables

I'm writing a small SQL Database browser. Requiered function is to select, update, insert,remove from two tables connected by a key. I've used OdbcAdapter to select from two tables and used bind to DataGrid, but OdbcCommandBuilder开发者_运维技巧 doesn't offer possibility to update contents when I'm using two connected tables. How I can achieve this function when it has to work on any tables from any database (numbers of colums are not specified).

Is it possible to make suggestions for specific fields values concerning their possible values (possible values of foreign key).

An updatable view should provide this for you - Oracle does support these. Here is an example: http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_8004.htm#i2126726