Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Junction table, sort of

284 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sean_Lake1
8 - Airtable Astronomer
8 - Airtable Astronomer

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.  

Sean_Lake1_0-1737586008513.png

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 2
Sean_Lake1
8 - Airtable Astronomer
8 - Airtable Astronomer

Sean_Lake1_0-1737586157378.png

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