APEX

Hello,

i am trying to create a Master-Detail Form and operate it successfully. Up to now i have failed to create a Detail Record in Detail form using the Create button. The reason for this is that the Foreign Key Field (Item) in the Detail table is not being populated with the value of the corresponding master table (field) after using the Create button. Actually all values of items is session are "Reset to NULL". Also the Detail Table is (initially) empty if this is of any issue.The master-detail form has been created using the corresponding wizzard.

Additionally:
The Update & Create Button in master form operates successfully. The Layout of Master-Detail was created using the option of "Edit Detail on Separate Page". The error is :

ORA-01400: can't insert NULL in ("WEBPOS"."IFACE_PROTOCOL_CATEG"."IFACE_PROTOCOL_ID")
Unable to process row of table IFACE_PROTOCOL_CATEG.
Return to application.

when pressing Save button in Detail Form. The Foreign Key Field (Item) is not displayed in Detail Form (Hidden and Protected) and of course its Primary (Surrogate) key that is populated in Before Insert Trigger.



Any idea how to overcome this ?



TIA