I have two tables in my database "Employees" and "History". The both tables contains the following fields.
Table 1: Employees
emp_id (int)
emp_name (varchar)
Posting_section (varchar)
Table 2: History
emp_id (int)
emp_name (varchar)
Posting_section (varchar)
On updating the Empolyees table the data is automatically inserted in the history table. In the view page of the specific employee of Employees table I inserted a button and want to show the all the records of history table of the same employee. How should I can complete this task.
Thanks in advance