Jan-
I would guess your relationships are like this:
Emails <— Patrons —> Status
A query will remain updatable as long as you follow a one-to-many chain down. So, a query that contained just Patrons and Emails or just Patrons and Status should be updatable. When you include all there tables, the query returns the Cartesian Product of Emails and Status for each Patron. So, if there are two emails and three status records, you will get six (2 times 3) records. Each of the email values will be repeated three times - once for each status. And each status will be repeated twice - once for each email. Because the query doesn't return unique values, it's not updatable.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Mar 31, 2015, at 4:05 AM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar