update multiple tables query?

[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

 

[John Vinson]

My main question is- Is it possible to have a data
entry form that updates 3 tables without using subforms?

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>