Skip to main content

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?

 

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

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

Reply


Terms & Conditions