I have 20 tables that correlate to 20 different clients. In each of those tables there are a few rows have entries with deadline date fields. For each of the 20 tables I would like to send those few specific rows to a 21st table called “Master Deadline Overview” so I can look at it in Calendar view and see all 20 clients deadlines at once with all of the fields from the original table entry in tact, and if I juggle the date around it will update on the original clients table.
I am very much a newbie and I can not figure out how to accomplish this. If anyone has a suggestion on how I might be able to get to where I am trying to go I would be greatly appreciative.