Jan 22, 2025 02:47 PM
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?
Jan 22, 2025 02:49 PM
This is the Milestones, task broken down, but I'd like to have each of these for each FS listing.
Jan 22, 2025 09:02 PM
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