I am trying to create a master editorial calendar to manage my organization’s newsletters, and I suspect I’m getting stumped by both the limitations of the primary field and how to properly use the lookup field when it comes to linking records between tables.
I want both an overall view of the entire newsletter production process in one table as well as separate tables for each newsletter and its respective issues. But I need the tables to talk to each other. The issues, deadlines and story lists should populate between the master production schedule and each newsletter’s production schedule. If a staff member changes a date or story in the newsletter tables, it should automatically be updated in the master list table. But every approach I try fails and/or creates a bunch of duplicate fields in a table that I don’t understand. Sometimes I can get tables to link and sync, and later it turns into a configuration error.
I feel like I need someone else to look at my extremely simple base to see what I’m doing wrong.
What am I missing to make this work?