update multiple tables query?

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

Guest

I am trying to create a data entry form that I can update
3 different tables that only have intermediate
relationships using an update query, I've tried with a
regular query and no luck.
My main question is- Is it possible to have a data
entry form that updates 3 tables without using subforms?

Can the setValue help me?
I create the update query and Access won't allow me to
use it for the recordset?
Help please Thanks
Silas
 
My main question is- Is it possible to have a data
entry form that updates 3 tables without using subforms?
Click to expand...

Not with indeterminate relationships, no (since Access cannot uniquely
identify which record is to be updated).

What are these tables? Why are the relationships indeterminate - are
they indeterminate in the real world, or are they in fact one to many?
What do you have against subforms? <g>
 
Back
Top