By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,759 Members | 1,778 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,759 IT Pros & Developers. It's quick & easy.

Auto populating a table

P: 3
Hello..

I'm hoping someone could help me out with this access problem..

I want to create a table that draws information from an already populated table (tblEmployee). This new table will include additional fields such as:

Undergrad School (could be more than 1)
Degree Attained (could be more than 1)
Grad School (could be more than 1)
Grad degree (could be more than 1)
Previous Employeer (could be more than 1)

I created a table named tblEEInfo and the field EEID is link to tblEmployee EEID (one to many)

however, when I click on tblEEInfo it has blank information. Any thoughts on how to get this populated? Form or query or report?

Thank you so much!
Jan 23 '08 #1
Share this Question
Share on Google+
7 Replies


JKing
Expert 100+
P: 1,206
Hello..

I'm hoping someone could help me out with this access problem..

I want to create a table that draws information from an already populated table (tblEmployee). This new table will include additional fields such as:

Undergrad School (could be more than 1)
Degree Attained (could be more than 1)
Grad School (could be more than 1)
Grad degree (could be more than 1)
Previous Employeer (could be more than 1)

I created a table named tblEEInfo and the field EEID is link to tblEmployee EEID (one to many)

however, when I click on tblEEInfo it has blank information. Any thoughts on how to get this populated? Form or query or report?

Thank you so much!
You can use an INSERT INTO or "Append" query.

Now I'm assuming you want all EEIDs from tblEmployee to be transfered into tblEEInfo.

Here's a query to do that.
Expand|Select|Wrap|Line Numbers
  1. INSERT INTO tblEEInfo ( EEID)
  2. SELECT tblEmployee.EEID 
  3. FROM tblEmployee
  4.  
Jan 23 '08 #2

MindBender77
100+
P: 234
Hello..

I'm hoping someone could help me out with this access problem..

I want to create a table that draws information from an already populated table (tblEmployee). This new table will include additional fields such as:

Undergrad School (could be more than 1)
Degree Attained (could be more than 1)
Grad School (could be more than 1)
Grad degree (could be more than 1)
Previous Employeer (could be more than 1)

I created a table named tblEEInfo and the field EEID is link to tblEmployee EEID (one to many)

however, when I click on tblEEInfo it has blank information. Any thoughts on how to get this populated? Form or query or report?

Thank you so much!
You could design a "MakeTable" query. You can do this by opening up a new query in design view, change the query type to Make Table.

Next, choose the name of the new table. Then select which table to pull the information from, in your case it will be the tblEmployee table.

This should create a table with all the information you need and criteria you specified.

Hope this Helps,
JS
Jan 23 '08 #3

P: 3
Hi all...

If a record change in tblEmployee somewhere down the road (employee's last name change) will that update the tblEEInfo?
Jan 23 '08 #4

JKing
Expert 100+
P: 1,206
This is hard to say without knowing your database design...

You shouldn't be storing the last name in two places though.

I suggest having a look at this article on Database Normalization How To: Database Normalization
Jan 23 '08 #5

P: 3
Here's how I've envision the table to work:

Fields on tblEmployee:
EEID (primary key)
FirstName
LastName
HireDate
Level
Email
Location

Fields on tblEEInfo:
EEINFOID (primary key)
EEID (connected to tblEmployee)
College1 (coming from tblCollege)
College2 (coming from tblCollege)
Degree1 (coming from tblColDegree)
Degree2 (coming from tblColDegree)
GradSchool1 (coming from tblGradSchool)
GradSChool2 (coming from tblGradSchool)
GradDegree1 (coming from tblGradDegree)
GradDegree2 (coming from tblGradDegree)
PrevEmplyr1
PrevEmplyr2

I want to create a form that will update tblEEInfo to look like this:

FirstName, LastName
HireDate Level
PH# Email
College1
Degree1
College2
Degree2
GradSchool1
GradDegree1
GradSchool2
GradDegree2
PrevEmplyr1
PrevEmplyr2

When the form is opened, the user should be able to enter the data to populate tblEEINFO. The form however should be pulling the name from tblEmployee.

I will then create a report that displays all employees with their respective degrees/college/previous employeers.

Is this hard to do?
Jan 23 '08 #6

P: 2
I am having the same problem as tiger3p...if anyone know how to get this accomplished that would be of great help, thank you!!!

I also thought of the Append or Update table option but again have the same question as tiger3p, will any changes to the original tables automatically update the table I created, or do I have to have a macro to periodically update the table?


HELP!!!!
Jun 10 '10 #7

P: 2
Not sure if this will work but this is what i am going to try...

Create an update query that updates the info from the tblEmployee to the tblEEInfo.

Create a macro that will run the update query, then open the form to update the tblEEInfo.

As long as you open the from via the macro, your info on your form should be the latest and greatest.

Not sure if this will work, seems like it will, but that's what I'm going to try.
Jun 10 '10 #8

Post your reply

Sign in to post your reply or Sign up for a free account.