Auto populating a table

[tiger3p]

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!

[JKing]

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.

INSERT INTO tblEEInfo ( EEID)
SELECT tblEmployee.EEID 
FROM tblEmployee
 

[MindBender77]

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

[tiger3p]

Hi all...

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

[JKing]

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

[tiger3p]

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?

[felito624]

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!!!!

[felito624]

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.