Welcome back to filemaker. Do you have a good entity list? If not try to right out all the main processes the database will need to perform and pick out all the nouns in the prose. These will be your entity candidates. From there you can begin to identify the attributes from the entities. The entities left will be your base tables, more/less, but remember it is not a precise science, rather a skill. So practice is the key. Many to many relationships are resolved with join tables, which exist for the sole purpose of simplifying data access, they’re the crossroads where two entities meet and record the common fields of the meeting.
Since it is a skill, your best help will come from providing us the prose & your impression of the nouns ( entity list vs. attribute list ) and ask for help / pointers for how to approach the joins needed to diagram it up.
Hope This Helps,
Thank you, that was indeed helpful. I'm lucky in that there is not a tight deadline. I'm taking this on as a summer project. I'll revisit the step you suggested and also review the sessions on Lynda.com