Hi all,
I face the problem as follow:
i got several column in table "transaction"
the table consists of columns
transaction_id (PK)
username (FK)
equipment (FK)
The form consists of these 3 columns,
i would like to have username automatically shown as a displayed text by mapping to app_user.
However, the value is treated as a null value when i tried to insert into table transaction.
the error is as follow:
ORA-01400: cannot insert NULL into ("ITEMS"."TRANSACTION"."USERNAME")
Unable to process row of table TRANSACTION.
i post in this thread
1001731
but i am not able to solve the problem also, please advice.
it is quite urgent for me.
Thanks for the advance.