4 Replies Latest reply on Aug 16, 2010 3:29 PM by philmodjunk

    Newbie - Which Table and How?

    RebeccaBoyd

      Title

      Newbie - Which Table and How?

        • 1. Re: Newbie - Which Table and How?
          RebeccaBoyd

          Oops! I didn't post my question! I am a new user to Pro11. i am using a PC and am a single user. I Currently am trying to link two many-to-many tables together.

          I have a Teacher Table with the following fields, pkTeacherID, fkSchoolID, LastName, FirstName, Title and Grade

          I have a Workshop Table with the following fields, pkWorkshopID, Presenter, Type, Title, Date, and I have included a Participants field. I do not know how to list the teachers in this Table.

          I know I need a 'linking' table since it is a many-to-many, but I will need to print reports letting me know how many teachers attended specific workshops, that will ultimately lead me to which schools participated.

          Where do I put this information?

          • 2. Re: Newbie - Which Table and How?
            philmodjunk

            Presumably you're using a set up like this demo file uses to link "contracts" to "companies".

            You'd base such a report on your join table, but add fields from your teacher and workshop tables where needed to the report layout.

            • 3. Re: Newbie - Which Table and How?
              RebeccaBoyd

              I am not going to download the demo.

              The two tables will be connected by the pkTeachers and pkWorkshops.

              How does my linking table know that specific teachers went to a specific workshop? Are they listed in the Workshop Table? I am new to the program and need specific details.

              Thank you

              • 4. Re: Newbie - Which Table and How?
                philmodjunk

                That's one of the reasons I suggested downloading the demo. It helps to be sure that you've defined the correct relationships between your join and data tables.

                Teachers----<join>----Workshops

                Since each record represents one teacher attending one workshop. You can build a layout based on the Join table that lists the ID numbers of every Workshop and every Teacher attending. The relationships that I hope you have defined link this record in the join table to one Teacher record and one Workshop record.  Thus, you can place fields such as the Workshop and Teacher names on your Join based layout and the fields will display information from the correct Teacher and Workshop record.

                You can sort such a report to group all Join records by Workshop Title to list the teachers for each Workshop. You can place the Workshop name in a subsummary part "When sorted by Workshop Name" to use as a sub heading for each group of records.

                If you are new to summary reports, you may want to look at this tutorial for some ideas and examples:  

                Creating Filemaker Pro summary reports--Tutorial