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