DCCoolBreeze
Programmer
OK. Here is a problem. I have two views. One Main and one Detail similar to tables that are Main and detail (I have to use a union all to combine two main tables and two details tables)...anyway, I have created two data blocks (1) main and (2) detail. I have changed on-lock, on-update and on-delete triggers for both so I can update and delete the records. The main works fine. I can update and delete without problem; however, I cannot update the detail view. I get a FRM-40200 field is not updateable error. The update flag is set to true. What can I do to be able to treat two views like two tables (main and detail)