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.

Re: Junction table, sort of

280 1
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