Hmm. is there a way to get an update-able "global view" of my data across the tables?
On 3/31/2015 3:31 AM, John Viescas JohnV@msn.com [MS_Access_Professionals] wrote:
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, AuthorMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access ApplicationsSQL 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: "jan.hertzsch" <jan.hertzsch@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar