Links on forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am making a database that will have accident and Injuries for our
employees. Right now I have one form with Employee Information that form has
a link to a form for Injury Information and that form has a subform for
Injury cost. I would like to put a link on the employee information form that
has accident details and for that form to have a subform with accident cost.
I tried to do this in form wizard but it would not let me. I tried design
view and it would only let me add a subform but no link.
 
You can use your existing forms.
When you add a subform (and it is easiest with the wizard tool) you link
with the records to be seen in the subform - my guess would be EmpID or
something similar.
Then you really will be adding two subforms - in fact, if you add the costs
form as a subform to the injury, you only need add this pair once to the
employee form. Access will restrict the data to only present records that
match - much like subdatasheets.
 
Back
Top