I have created two tables one for job orders and one for drawings. with a one to many relationship. one job order to many drawings. I have a field called Auth_date in the job order table, and in the drawing table a field for how long a drawing takes to develop (INTV) and a date field for the auth_date plus intv(dwg_complete). Next I created a form in which the job order table supports the primary form and the drawing table supports the subform. What I am trying to do is when I fill in an authorized date in the job order table have it automaticly caculate the the date for dwg_complete for all related records. All of my attempts will only update one record, the other records will not update until I select each one. how do i get all of them to update at once?