I'm having a bit of trouble trying to figure out the design of a database using FMPro 6 that can be used in the following way:

When entering data begin by entering personal details in a 'Tutors' database, then enter the course details for the tutor - this will only

be a summary of (for example) course start date/time, course name, course venue and min/max places available. Multiple courses can be

added to each tutor record. To enter further details or view more course information one would click on a button to be transferred to

the related record in a 'Courses' database.

OK, I have no trouble with the above and created a portal in the Tutors database to show a few fields from Courses database... however, I have had trouble trying to figure out how to take into account the fact that some courses have more than one tutor. I assume this is a many-to-many relationship and attempted to sort this out with a third 'join' database but have not had any luck. If anyone has any suggestions about how I should proceed here I would appreciate some pointers.

Thanks

I have had trouble trying to figure out how to take into account the fact that some courses have more than one tutor. I assume this is a many-to-many relationship and attempted to sort this out with a third 'join' database but have not had any luck.

I don't see a join file in the structure you've described so far, but that's what you'll need here:

Course -< Course_Tutor >- Tutor

The Course_Tutor file relates to Course by CourseID and to Tutor by TutorID. This join file may also need copies of some of the fields from the other files if you wish to see those details in the portals. For example, you might want the Tutor Name for a list of Tutors in the Course file, and you might want the Course Title in a list of Courses in the Tutor file. These copies can be regular text/date/number fields with auto-enter lookups, or unstored calcs showing the related value.