Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
a) For FD Section, the Account num should take from the cv_Table (pick highest value).
b) DD section - the Account num should take from the cv_Table (pick highest value).
Note: after following the above rules, if the account having null value or spaces, then :-
a) If the person having single Account in CV_table then load it with same Account from Cv_table (i.e. Acc_Num from cv_Table)
b) If the person having multiple Accounts in CV_table, then default it to the first Account no from CV_table after sorting all the Account numbers in descending order.
For eg- If we have accounts – 620620 and 620622, then use the Account num as 620622. While defaulting, sort "descending" order meaning the "highest" numbered
Account will be used for the default.
Your question is not clear , what you want to do? Can you attached sample data ?
Can you provide some sample data with expected output ?