In Access 2010 I’m building an HR database & I need to produce an HR log to record such things as “annual review” – this table will have the following columns:
HRLogID | EmployeeID | Dated | Type | Summary | Notes
I want to store the log info in a separate table to the main table (“Main”) that stores a person’s record. The link between the two tables is EmployeeID.
I want the data to show & be able to be updated from a form called “Employee” which displays all the data on a person. The data source for this form is the table “Main”
Can anybody explain how I go about doing this – for some reason I have always had a mind blank when it comes to joining up tables in this manner, so a really basic step by step answer or example would be most appreciated.