Can you help me think through how many tables to set up for a base that helps us track our communications?
I would like to track communications by month, and we of course use several “channels” each month – FaceBook, e-mail, blog posts, newspaper articles. There are topics we might be repeating over a few months, e.g. notice of a scholarship application period that is open from January - March, so this topic might be covered for three months on several different media channels.
Ideally, I would like to be able to look at a view that shows what communications are scheduled by month, as well as what communications are planned by media channel.
Is there where I need a junction table? Or can I create a few tables that are linked?
THANKS! I really like this program but am not left-brain minded enough to be nimble at it.