Query with more than one table

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

Guest

I have a query using 2 tables. There is only one field from the second table
in the query. Works great but will not let me edit the values in any of the
fields. What am I missing?

Thanks
Paul
 
In the Access Help, it tells you that a query between to tables that are
one-to-many related is usually updatable, but there are some restrictions.
Since you don't provide a lot of information below, you might want to refer
to Help. Look for 'updatable queries' in the Answer Wizard. There aren't a
lot of hits.

Good Luck!
 
Hi,



If you WHERE clause implies the two tables in a comparison, try to move that
"criteria" into a inner JOIN.



ie:

SELECT .... FROM a, b WHERE a.f1=b.f2 AND a.f3=44 AND b.f4<66


into


SELECT .... FROM a INNER JOIN b ON a.f1=b.f2 WHERE a.f3=44 AND b.f4 <66


where I moved all the conditions implying both tables from the WHERE clause
into a JOIN.



That may not solve the problem, but if you use the WHERE clause to generate
implicit join, that generally does NOT work, for update.




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top