Updating a single record

[Guest]

Help,
I'm new to Access but I've worked through some tutorials. I've got two
tables, Equipment and Repairs. What I need to do is update the Hours field
in Equipment when I make an entry in the Hours field in repairs. The to
tables are linked by Equip Id field.

 

[Guest]

Why?
Just keep the detail in hours table and whenever you need it in a form or on
a report, calculate it. It's poor design to duplicate the information in
another table.

-Dorian