R
Ramesh
HI,
I have a table with staff info, personal info, designation, salary, etc
entered at the time of joining.
There s another table Hike which has records of each revision of salary and
another table Promotion for each revision of designation.
How can i get a report with the latest salary and designation, considering
those who have not gone thro revision, will not have a record in the Hike or
Promotion tables?
Am i doing right or is there a better way to organise the information?
Thanks for any help
Ramesh
I have a table with staff info, personal info, designation, salary, etc
entered at the time of joining.
There s another table Hike which has records of each revision of salary and
another table Promotion for each revision of designation.
How can i get a report with the latest salary and designation, considering
those who have not gone thro revision, will not have a record in the Hike or
Promotion tables?
Am i doing right or is there a better way to organise the information?
Thanks for any help
Ramesh