How would you link 2 tables - calendar of events and tasks

[Lindsay_Patross]

Hi everyone, 

I've got two tables in two different bases.

• calendar of articles
• tasks

I'd like to create a task for each calendar item and only need to update one table. 

Just looking for ideas on the best way to link these bases. 

My current idea:

• is to sync the calendar table into the base with the tasks
• link each calendar task to the calendar item. 
• Use an automation to update the task status

[TheTimeSavingCo]

Hmm, could you tell me more about your current idea and why you'd need an automation?

If you're updating the task statuses within the "Tasks" table, you could use lookups / rollups to pull the task statuses over to the events table to view them if needed?