subrecords

[Guest]

I'm trying to enter a table that has all of one persons training records into
a table that has the all of the employees base info as a subrecord. I'm new
to Access and have a lot of info already stored in the tables under the
individual names. How do I make it to where when I look at the main list of
employees, I can open a sub to each of the individual records?

 

[Guest]

What you need to do is open the form in design view, click on VIEW -
Properties, click on the subform, and set the Master/Child link to EmployeeID.

Set the subform to datasheet view.

 

[Larry Daugherty]

It is not a good idea to be viewing and manipulating data in *tables*.
Use forms instead to view and manipulate the data in your tables - for
a whole host of reasons.

There can be more than one answer to your question. The most usual
solution is the *Form/Subform*. In that paradigm, the form is based
on the higher level table and the subform is based on a related table.
With such a form/subform design, stepping the form through the main
table will cause the subform to show just the records related to the
record shown by the form. In the older versions of Access the Help
for *subform* was very good and gave step-by-step directions in
creating a form/subform instance.

I realize that the above leaves you with things to research and learn.
If you require more detailed help then post back with one issue per
post and describe what you have already done in your attempts to solve
that issue.

A couple of great newsgroups for newbies are:

microsoft.public.access.gettingstarted
microsoft.public.access.tablesdesign

HTH