How do I create an employee profile in a single report?

[techcrium]

I have an Employee Table with columns EmplID, FirstName, LastName, Birthdate, Gender, etc

I have a Position Table with columns PositionID, Title, Level, Description, StartDate, EndDate, etc

I have an Education Table with columns EmplID, School, StartDate, EndDate



How do I build a single profile which lists all of his info?

For example:

John Doe
Birth Date: 1980
Gender: M

Positions Held:
1996-2001 XXX Company Programmer
2001-2005 XXX Company Manager
2006-2012 XXX Director

Education:
1995-2000 XXX Computer Science
2001-2003 XXX MBA


I have been searching and people say build a subreport, but how do I filter it so that only his position shows and only his education shows on load?

I have a scroll down button on the main form which enables you to select all employees on the drop down.
Thanks!

 

[pbaldy]

Typically a subform/subreport is kept in sync with the main form/report with master/child links (properties of the subform/subreport container).

 

[techcrium]

ok i got it. Thanks!