hello,
i created a master detail page (menu option Products) and to make single view of master follow the instruction of sample interactive grid app page no.10 single row view, when close form and again open it from menu option Products, it is showing traditional view (grid view) and i have to press created button (SRV here) to show it in single view, can't we have this view permanent?
my master region has 3 columns total amount, discount
detail region has a column amount
i want to calculate total amount while user entering data, i used a dynamic action on amount column in detail to execute pl/sql code, wrote as below but when entered amount in detail region, pressed tab, it is showing error as below:
begin
:TOTAL_AMOUNT := nvl(:TOTAL_AMOUNT,0)+nvl(:AMOUNT,0);
end;
is this right way to calculate and reference master region columns? please help as on following link i found a solution but it is for when user going to save whole transactions.
https://stackoverflow.com/questions/9031613/calculate-sum-of-oracle-apex-tabular-form-field
ws: ptmws
user: developer
pwd: Infra123
application: 111533 TESTS
page #: 5 - Products
EDIT: i have removed net amount calculation as i realize it was wrong.