I have a projects File and a Meetings file (separate dbases). They are linked together. I am working in the meetings file and have tables for "meetings details, Minutes, and Action items".
Will any of these have the need for a join table?
I want a button that will take me to the minutes data entry screen and enter the meeting number.
The action items will be where I will produce a checklist of items that come out of each meeting related to a particular project.
I feel like I am going in circle and have no clear direction. maybe I have been playing with the relationship too much and now I am confused.
Any help, suggestions would be greatly appreciated.