Hi Sergey

Thanks and yes, I missed out the FK emp_no in table B

So the table structures should be

Table A
1. emp_no
2. name

Table B
1. emp_no
2. effective_date
3. event_sequence
4. event_type
5. Salary

Your advice is much appreciated

Thanks & Best Regards