Related Tables & updating them
Dear Experts
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.
Many thanks
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.
Many thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER