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
Solved

Related Tables & updating them

Posted on 2013-01-16
2
211 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
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

856 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