Which is best in this situation: Multiple Files or Multiple Tables?
I have used the Contact Management Template to create a file that has multiple tables. The file is for a District Office and it contains a Contact Table and a Church Table and it is working very well. Now I want to add events - several different events - a Ladies' Retreat, a Pastors' Briefings, etc. So is it better to create multiple tables within the same file based upon the Contact management? Or is it better to use the Event management template and have various tables for each event? In reading the documentation it states use multiple files if you think you'd use them in a variety of solutions - I'm not sure I would. The events would draw participants from the people in Contact Management.
Whichever way is better, I'm sure I'll have follow-up questions. But I don't want to start down the wrong road. Thanks for any advice before I begin.