Selasa, 31 Maret 2015

Re: [MS_AccessPros] Can't update in a Query

 

Jan-


Yes.  Use a form for Patrons and two subforms for Status and Emails.  To conserve space on your form, if necessary, you can put both subforms on a Tab control.

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 5:09 PM, 'jan.hertzsch' jan.hertzsch@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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, 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:

Jan,
 
Please provide the table relationships and SQL view. Are the tables joined on primary and foreign keys?
 
Duane Hookom, MVP
MS Access
 

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 30 Mar 2015 17:19:10 -0700
Subject: [MS_AccessPros] Can't update in a Query




I have a Query with 3 tables.  Patrons (my contact list) Emails (multiple email accounts per patron) and Status (Deceased, attended Fund Raising dinner, Donor, Board Member)


My links look ok and I am getting the correct data in the query but I cant update the records in the query.  None of the fields seem to allow update.


I am certain this is something simple but.....


Any thoughts?


Thanks





__._,_.___

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 (6)

.

__,_._,___

Tidak ada komentar:

Posting Komentar