SDO with foreign fields trying to update the foreign field v

Posted by dreslp on 31-Mar-2004 09:08

I have the following situation.

Parent table: CrossReference - has link to docDef via docObj.

Child table: CrossReference Records - has link to parent table via an obj value.

On the viewer - I have a field to filter a lookup that is using the parent table (CrossReference.docObj) value to lookup a child table of the docDef table.

The SDO on the viewer has a foreignField setup using the obj that ties the parent to the child, but it is also passing the parents obj value to the docDef table. This is then displayed on the viewer (but hidden) so that the lookup can be filtered by the docDef obj.

However, when I try to add a record, I get an error message saying that the docDef obj is not updateable.

Anybody got any ideas on how to make sure that the viewer is not trying to update the docDef obj?

All Replies

This thread is closed