recordset from a query on a query not updateable

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

Guest

I have a simple table and have built two queries on this table each of which
filters for a different condition. I've then put both of these queries in a
new query to produced a recordset returning both results filtered for (to
link child and master in a subform). I've joined the two tables (return only
when both equal - which is always as they are from the same table) - and this
reduces the variations returned. I then put this in a subform but only when
one of the common fields is the same as the master form.
Problem is the first queries are updatable, the second is not.

If anyone can help with this, GREAT,
of if you have a better way of doing the same thing, pls advise.

Jonathan
 
Queries are generally updateable when the joined fields represent primary
and foreign key fields.
 
Back
Top