Skip to main content

Junction table, sort of

  • January 22, 2025
  • 2 replies
  • 34 views

Sean_Lake1
Forum|alt.badge.img+20

Hey all.

I have tasks that are laid out and currently in one table - Milestones.  I have another table with Event names.

The idea is each Event will have all the tasks in the Milestones/task listing table.  

SO that when I group by each Event, the tasks can be worked on for THAT event, they're the same tasks, but need to be linked to each Event separately.  Does that make sense.

I created a third table as a sort of junction table and created two linked fields, one for the Event and the Other for the Milestone/task listing.  

The above table is the "junction table".  Did I need to do it this way?  Or just I've just added the task linked table in the FS Listings?

Any ideas?

 

2 replies

Sean_Lake1
Forum|alt.badge.img+20
  • Author
  • Inspiring
  • January 22, 2025

This is the Milestones, task broken down, but I'd like to have each of these for each FS listing.


TheTimeSavingCo
Forum|alt.badge.img+31

This is the Milestones, task broken down, but I'd like to have each of these for each FS listing.


If I'm understanding right, the 'Milestones' table is like a bunch of task templates that need to be assigned to each event?  If so, yeah, junction table seems like the way to go