Dear Sir,
We have to tables like the staff table and the staff salary table
The staff table contains the details like the
Staff ID (PK)
Staff name
Designation...
Currently Working (Yes/ No)
And the staff salary table contains the salary month, staff id, basic Salary, over time allowances and the total amount to be paid..
We need to do the follwing
When we select a particular month all the staff id and the staff name who are currently working has to be displayed in rows like the below form
No Staff Name Staff ID Basic Salary Overtime Allowance Total Amount
1 KKKKK 123 2000 1000 3000
2 YYYYYY 101 2200 100 2300
Please advise how to do the same....
We have to tables like the staff table and the staff salary table
The staff table contains the details like the
Staff ID (PK)
Staff name
Designation...
Currently Working (Yes/ No)
And the staff salary table contains the salary month, staff id, basic Salary, over time allowances and the total amount to be paid..
We need to do the follwing
When we select a particular month all the staff id and the staff name who are currently working has to be displayed in rows like the below form
No Staff Name Staff ID Basic Salary Overtime Allowance Total Amount
1 KKKKK 123 2000 1000 3000
2 YYYYYY 101 2200 100 2300
Please advise how to do the same....
