We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 3632
    • 22 Posts
    Easy thing to do would be to either have a hidden field populated by the correct week number or get them to choose it when they’re entering bigs but storing the bigs separately may lead to issues later though I guess you could link the stats to the bigs on week_id - just don’t really see the point of adding another table when you don’t have to - depending on the aggregation you may be called to do down the line it might make things messier just for a easy path now - in any case you do have to store the stats smiley
      • 3632
      • 22 Posts
      No grin
        • 813 ☆ A M B ☆
        • 326 Posts
        Neither do I. That’s the problem!
          • 813 ☆ A M B ☆
          • 326 Posts
          If anyone’s still reading this and would like some clarification, I put together a narrative with some sample schema:

          http://dl.dropbox.com/u/2180905/schema.html