Showing multiple entries in form

[Nan]

How can I show multiple entries of an employees work history sorted by date
increments in a form where the header holds an employees name and the detail
holds work history? My problem is that I want to see all the entries for an
employees work history associated with their name on the form at once...
right now each date range entry is being viewed as its own record (i.e., John
Smith has 5 records because he has entered 5 entries reflective of his work
history... I just want to have his name shown once and the work history to
display all at once regardless of the number of entries)? Hope this makes
sense???

Thanks!

 

[John W. Vinson]

How can I show multiple entries of an employees work history sorted by date
increments in a form where the header holds an employees name and the detail
holds work history? My problem is that I want to see all the entries for an
employees work history associated with their name on the form at once...
right now each date range entry is being viewed as its own record (i.e., John
Smith has 5 records because he has entered 5 entries reflective of his work
history... I just want to have his name shown once and the work history to
display all at once regardless of the number of entries)? Hope this makes
sense???

Thanks!

You don't describe the structure of your tables, but a typical way to do this
would use a Form based on the employees table (showing the name and other
biographical information), with a continuous Subform bound to the work history
table, linked by the employee ID (the primary key of the employee's table to
the corresponding foreign key in the history table).

If this isn't making sense please post the field definitions of your two
tables and indicate how they are related.

 

[Nan]

Hi John, Thank you.

My tables are set up as you have described. I think what I am missing is
exactly what you have suggested.... "with a continuous Subform bound to the
work history
table," --- How do I do this?

 

[John W. Vinson]

Hi John, Thank you.

My tables are set up as you have described. I think what I am missing is
exactly what you have suggested.... "with a continuous Subform bound to the
work history
table," --- How do I do this?

One of several ways:

Create a new Form based on the work history table.
View its Properties; set the "Default View" property to Continuous Form.
Arrange the controls for whatever fields you want to see at the top of the
design window, and drag the bottom of the window up to the bottom of the
controls.
Save the form.
Open the (Single view) main form in design mode.
Drag the new work history form onto the mainform, positioned where you want
it.
If asked, define the Master and Child Link Fields to be the EmployeeID.