Populating some fields in a table from another table 1

[tiger3p]

Hello ..

I have a table called tblEmployee with the data...

I created a seperate table labeled tblEEINFO.. the fields on this table contains link to tblEmployee on the following fields:

EEID = employee id
STATUSID = full-time or part-time
OFFICEID = location of employee


This table also have the following fields which is the same as in tblEmployee:

LastName
FirstName
Phone#
Email

The fields below are new fields specifically for tblEEINFO
Undergrad School
Degree 1
Undergrad School 2
Degree 2
Undergrad School 3
Degree 3
Grad School 1
Grad Degree 1
Grad School 2
Grad Degree 2
Previous Employer

Now .. I want tblEEINFO to be populated with the data already in tblEmployee (lastname, firstname, phone#, email).

Is there a way to do this??

Thanks so much and sorry if I confuse anyone.

 

[tiger3p]

Let me try another link...

 

[MajP]

You should have three individual continous subforms: certification, education, and employer. It does not look like you have three subform.

To make these subforms look good. Set the record selector, dividing line, navigation bar to "no". Set them up in a tabular form.

The subforms should be continous subforms, and for format they should probably be tabular. They then would look like this

SchoolType School Degree
College Univ. of Maine BS - Eng
College Univ. of Toledo BS - Acct
Grad GWU MS - Eng


Not
College
Univ of Main
BS - Eng

College
Univ of Toledo
BS-Acct

I am not sure what you are doing, but it does not look like you have three continous subforms. You can put these continous subforms on individual tabs of a tab control.

 

[tiger3p]

The subforms should be continous subforms, and for format they should probably be tabular. They then would look like this

SchoolType School Degree
College Univ. of Maine BS - Eng
College Univ. of Toledo BS - Acct
Grad GWU MS - Eng

To make the form display like this? Should I be doing the following on the subform:

CollegeName: CollegeType: DegreeObtained:
CollegeName Data CollegeType Data DegreeObtained Data
CollegeName Data CollegeType Data DegreeObtained Data
CollegeName Data CollegeType Data DegreeObtained Data


I tried putting a subform within a subform and it would not let me do a continous form.

Here's the design

 

[tiger3p]

Here's a copy of my database....minus the sensitive informations..

I'm interested on how to make the tab go back to the Company Info tab when you switched to a different name (record)..

 

[tiger3p]

how do you create a report out of the form? I think I'm able to display what's needed in the form/subform...

I'm having trouble creating a query and report to display the following:

Joe Smith

College: Univ. of Florida
Degree: Undergrad
Type: BS Accounting
College Univ of Miami
Degree: Grad
Type: MS Accounting

Thanks again to all in advance!

 

[MajP]

Private Sub Form_Current()
  Me.TabCtl0.Value = 0
End Sub

Just like the form
Main report based on tblEE with a sub report based on tbl education. Just do not put the fields side by side, instead put the fields

CollegeName
CollegeType
DegreeObtained

 

[tiger3p]

Hi MajP,

Do you have an example of a report with a subreport? Should I be doing a union query?

 

[MajP]

Access ships with a Northwind.mdb Look in this database. There is a report "Catalog" with a subreport "Subreport Catalog".

No union query. All education information is contained in tblEducation. Should be just like a form, subform.

 

[tiger3p]

Private Sub Form_Current()
Me.TabCtl0.Value = 0
End Sub

What does this code do?

 

[MajP]

I'm interested on how to make the tab go back to the Company Info tab when you switched to a different name (record)..

The current event fires when you change a record.
Tab(0) is your first tab with company info.

 

[tiger3p]

Ah.. Thank you..

Is there a way to display tblEmployee, tblEducation, tblEmployer all in one query? I tried doing a query through query wizard and I don't think the result is correct. for the database I have posted above, each employee is getting 8 records even after I do a "group by"..

 

[MajP]

You can, but it probably will not look the way you are thinking.

Assume you have 3 educations and 4 previous employers, then you will get 12 records (3x4) for that person. Each combination.

I would recommend using subreports.