How do you set up a relationship between dates in 2 tables where your matching dates and counting the number of dates in Table 1 (summary count, I assume).

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

My intent is to get an idea of how to create the relationship using the dates (linked via the Unique ID's in both tables) and then provide a count back into Table 2 to be displayed alongside each the Table ID and Date in a report.

My problem is how exactly to create the relationship with the dates being the focus rather than the Numeric Unique ID's.

Photo of Mel42

Mel42

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
You will need to make the Key field of one of your Tables be the Date field. (I suggest trying this first on a Copy of your app).

Then make a Relationship and on the right side of the relationship, use the Date field of the other Table when you are building the Relationship.