Elizabeth-
So the related table is Client? That should give you a 1-M relationship to this
table as long as you include ClientID. Each client will have multiple events
consisting of an EventID and the date the event occurred.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
---------------------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
Sent: Monday, April 30, 2012 8:45 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] table design
The dates are when forms are sent to clients and received back from clients. I
was going to have them in one table
ID
Event_ID (key to the event description, i.e. Form "A" Sent Date)
Date
The attributes are about the client. Do you need more info? Thanks for your
help.
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Elizabeth-
>
> Need more info. What are these "dates" related to? Why aren't they in their
> related table(s)? One-one joins are a pain the patootie.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -----------------------------
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
> Sent: Monday, April 30, 2012 5:36 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] table design
>
>
> Hi there-
>
> I have many, many attributes and a factless fact table (dates of events). My
> first thought is that I'd like to put the attributes in separate tables by
> subject matter and have one to one joins. But then I thought I better ask you
> all if you thought Access would run faster if the attributes were in one wide
> table.
>
> Thanks,
> Elizabeth
>
Tidak ada komentar:
Posting Komentar