Hi to everyone,
Please help me figure out how to do this... I have a two (2) Tables (Employee Table & Salary Table)...In my Employee Table I have a field salary....and I have also Portal from my Salary Table with a field Position, Date Hired, and Salary.
What I want to happen is if I will update my salary table in my portal, it will also automatically update the latest salary of an employee in my Employee Table. Kindly help me figure out if there is any calculation needed in my Salary field in my employee Table.
Thank you very much.