Hi,
I have created sample 'cash receipt' form. It's a 'form on report' page. During new record creation, I want to set FINANCIAL_YEAR column with global variable G_FINANCIAL_YEAR value and RECEIPT_NO with pl/sql return value by querying last receipt no from table RECEIPT. How can I do these things in the form? I use APEX 4.2.6 EPG.
Both these two columns (FINANCIAL_YEAR & RECEIPT_NO) are part of Primary Key.
Thanks,
-Anand