Hi,
On our main computer system (designed by Oracle 18 years ago incidentally) we have many primary keys and foreign compound keys with more than 2 fields. It seems the maximum number of key fields that APEX will accept when creating a master to detail tabular form is 2 however. Apparently this will increase to 5 when APEX 5 is released but this will still be too small for us. I understand that the use of ROWID link was introduced relatively recently but my master form is often based on a query with more than 1 table and the ROWID of the master table is not retrievable in that case.
Does anyone know of a way to populate the key columns in the detail table with the values in the master table when a record is inserted.
I did not have this problem with Forms or JDeveloper but I am not allowed to use these anymore for different reasons (obsolescence and difficulty of maintenance).
I usually manage to solve problems like this but this one is proving to be intractable.
Any help would be gratefully received.