A
Abdul Shakeel
I have three tables name tblDeaprtments, tblEmployees, tblPayroll
tbldepartment contains fields
DepartmentID &
DepartmentName
tblEmployess contains fields
EmployeeID,
EmployeeName,
AccountNo.
BasicSalary,
HoseRentAllowance &
ConveyanceAllowance
tblpayoll contains fields
payrollID,
MonthStartDate,
MonthendDate,
EmployeeID,
DepartmentID
I just want to make a form where I first enter a payroll ID month start date
& month end date then I select department ID which automatically updates
Employees in that particular department when I select a particular employee
his Basic salary, House rent Allowance & Conveyance allowance update
automatically with the figures of tblemployees
tbldepartment contains fields
DepartmentID &
DepartmentName
tblEmployess contains fields
EmployeeID,
EmployeeName,
AccountNo.
BasicSalary,
HoseRentAllowance &
ConveyanceAllowance
tblpayoll contains fields
payrollID,
MonthStartDate,
MonthendDate,
EmployeeID,
DepartmentID
I just want to make a form where I first enter a payroll ID month start date
& month end date then I select department ID which automatically updates
Employees in that particular department when I select a particular employee
his Basic salary, House rent Allowance & Conveyance allowance update
automatically with the figures of tblemployees