Forum Discussion

TimEgerton's avatar
TimEgerton
Qrew Trainee
3 years ago

Year/Months Table Question

Hi,

Is there any advantage or disadvantage in having (a) a two table setup with Years have many Months compared to (b) a single table of Years/Months (2021-08).

Just starting on a new app.

Thanks,

------------------------------
Tim Egerton
------------------------------

2 Replies

  • One table with a key field of YYYY-MM will give you the most future flexibility.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • TimEgerton's avatar
      TimEgerton
      Qrew Trainee
      Thanks Mark.

      ------------------------------
      Tim Egerton
      ------------------------------