Form doesn't update all tables

  • Thread starter Thread starter Carrie again
  • Start date Start date
C

Carrie again

Thanks for the previous answer. Sure enough, I tried
doing the form in design view and it works. Now, I'm
having another problem.

Each table has a one to many relationship with the Req# in
the Main table; however the forms include data from the
main table and table A (or B, C...). When I enter the
data in the form, it updates the appropriate information
in the Main table but not in the other table. Any idea
what I'm doing wrong?

Thanks again - this database is a lot more complicated
than anything I built before
 
It will not populate all tables..it will populate only
those to which you are attaching the control by using the
controlsource property.
To Update the other tables you will have to do that
seperately.

But here is the deal...you must write a query to obtain
the records and since you have a join...


your query would be something like...

select reqno,field 2 etc from table 2 where table1.req
=table2.req

Hope that helps.
 
Back
Top