I have two table called: Commutation Matrix and Membership Exit, in commutation matrix table are fields as follow: Schedule (code 10), Age (integer), Gender (option: Male,Female), Nx (decimal), Dx (decimal), why Membership Exit table are fields as follow: No. (code 10), Member No. (code 20 link to vendor table), member name (text 80), Age (decimal), Gender (Option: Male,Female), NxDx (decimal), nc (decimal).
From Commutation Matrix table, I design a page called Commutation which contains data for both male and female separately.
Schedule Age Gender Nx Dx Nx/Dx
F 40 Male 479,949.2862 39,615.3130 12.115246590
F 40 Female 493,761.6769 39,701.1114 12.436973650
From the Membership Exit table under C/AL of Age, I wrote these code
The definition in the Global variable;
CommutationTable Record Commutation Matrix
member Record Membership Exit
IF member.GET(MemberNo) THEN
IF member.Gender = member.Gender::Male THEN
IF CommutationTable.FIND('-') THEN
MESSAGE('The Pencom table has not been imported for this age please check and import');
I designed a page called Membership Exits from Membership Exit table:
From page, when i inputted the Age. It gave me the value for Female even when i chose Male as a Gender.
Please help me out,