Solved

Related Tables & updating them

Posted on 2013-01-16
2
212 Views
Last Modified: 2013-01-16
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
Comment
Question by:correlate
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 38781753
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
 

Author Closing Comment

by:correlate
ID: 38781799
Perfect, thank you - at last it all makes sense
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question