• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

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
0
correlate
Asked:
correlate
1 Solution
 
als315Commented:
1. Create table with desired fields (HRLogID - autonumber, EmployeeID long integer, if in table Main it is autonumber).
2. Add table to DB Relations (One-to many from Main to this table)
3. Create subform on main form with employees details. Master field - EmployeeID from main form, Child - EmployeeID from this subform. You can also set default value for Dated field to =Date() or =Now() if you like to fill it with current date (date/time)
0
 
correlateAuthor Commented:
Perfect, thank you - at last it all makes sense
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now