Recent content by Donna Kelly

  1. D

    Snowflake Schema . . . or . . . Lookup of a Lookup

    @CJ London No-one could disagree with this as a statement of principle, particularly when discussing logical design. However, I feel that best practice physical design does vary dramatically depending on the implementation purpose and platform. As you so validly point out, techniques also...
  2. D

    Snowflake Schema . . . or . . . Lookup of a Lookup

    @GinaWhipp. Thank you for this. It's kind of you. Unfortunately, Desktop or Cloud is the fundamental design decision, and my original post was to do with "Help with best practice design for a web database, please!". This application needs to be available to users in different cities, on...
  3. D

    2010 versus 2013

    @GinaWhipp. I am sorry for being unclear. When I said "I'm creating a (relatively) simple web application and I'm using 2010" I meant that this was a 2010 Web Database. My question related to the 2013 environment, and migration of a 2010 Web Database to a 2013 Web App. VBA never came into...
  4. D

    Snowflake Schema . . . or . . . Lookup of a Lookup

    @CJ London. Again, I am sorry for not being clear. No I am not saying that I can't create a query. I am saying that when I open the table in my database (equivalent to Product in my example), in the Database Tools tab of the Ribbon, the Relationships button is grayed out. In desktop mode, I...
  5. D

    Snowflake Schema . . . or . . . Lookup of a Lookup

    @plog I'm sorry my comment "If this was SQL Server, I'd have no problems at all" made no sense. I will try to be more clear. To illustrate my comment, I created the 3NF structure in SQL Server. Then I generated the script. This is the code shown below. It fully and precisely defines the...
  6. D

    2010 versus 2013

    Hi Folks, I'm creating a (relatively) simple web application and I'm using 2010 because my end users have 2010, and if they ever need to download/maintain the application, then all will be well. However, SharePoint Online is a 2013 environment, and more to the point, uses SQL Server instead...
  7. D

    Hi from St Helens, Lancashire

    Hi Scott thanks for the hello, and St Helens is . . . SUNNY! :cool: Cheers, Donna
  8. D

    Snowflake Schema . . . or . . . Lookup of a Lookup

    Help with best practice design for a web database, please! I have a 3NF logical design that looks like this: Table Category. Fields CatID (PK), CatDesc Table Range. Fields RangeID (PK), RangeDesc, CatID (FK) Table Color. Fields ColID (PK), ColDesc Table Product...
  9. D

    Hi from St Helens, Lancashire

    Hi Folks, I've used Access on and off over the years, mainly for little desktop applications (hate the word 'apps'). Now I'd like to create some Sharepoint Online applications, and Access seems to be the way to go . . . so I will be asking for a lot of help, people! Cheers, Donna
Top Bottom