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