Page design in Microsoft Dynamics NAV 2017

Hi,

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

CommutationTable.RESET;
CommutationTable.SETRANGE(CommutationTable.Age,AgeatExit);
IF member.GET(MemberNo) THEN
//MESSAGE('%1',member.Gender);

IF member.Gender = member.Gender::Male THEN

CommutationTable.SETRANGE(CommutationTable.Gender,CommutationTable.Gender::Male)
ELSE
CommutationTable.SETRANGE(CommutationTable.Gender,CommutationTable.Gender::Female);


IF CommutationTable.FIND('-') THEN
BEGIN
CommFactor:=CommutationTable."Nx/Dx"
END
ELSE
MESSAGE('The Pencom table has not been imported for this age please check and import');

nc:=NxDx-(11/24);

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,

Thanks,

Parents Reply Children
Related
Recommended