employeeTbl.SetFilter("AD user name", UserId);
if employeeTbl.FindFirst() then begin
FilterGroup(2);
AbsenceRegistrationTbl.SetFilter("Employee No.", employeeTbl."No.");
if AbsenceRegistrationTbl.FindFirst() then begin
SetTableView(AbsenceRegistrationTbl);
SetRecord(AbsenceRegistrationTbl);
end
else begin
SetTableView(AbsenceRegistrationTbl);
SetRecord(AbsenceRegistrationTbl);
Message('No record found');
end;
FilterGroup(0);
exit;
end
ELSE begin
AbsenceRegistrationTbl.SetRange("Employee No.", employeeTbl."No.");
if AbsenceRegistrationTbl.Find() then begin
FilterGroup(2);
SetTableView(AbsenceRegistrationTbl);
SetRecord(AbsenceRegistrationTbl);
end;
Message('Logged In User is not tagged with any employee');
FilterGroup(0);
exit;
end;
**For your reference:--
var
employeeTbl : Record Employee;
AbsenceRegistrationTbl: Record "Employee Absence";
