2 Replies Latest reply on Nov 21, 2011 6:55 AM by uaykylie

    Totally new to Filemaker and just getting started messing with a really basic database. The fields...

    uaykylie

      Post

      Totally new to Filemaker and just getting started messing with a really basic database.  The fields in the db are Date, F Name, L Name, Volunteer Activity, Adult or Youth, Amount of time.  I want to print out just a list of all Adults with no repeats of the name i.e. only one line for each volunteer even if they have volunteered more than once.  Is it possible in a db set up like this or do I need to set it up differently?

        • 1. Re: Totally new to Filemaker and just getting started messing with a really basic database. The fields...
          LaRetta_1

          Hi Kylie,

          You can create a report with a leading part based upon the volunteer.  Put their name in the leading part, delete the body of the report, sort by volunteer and preview.  But it smacks of an underlying issue and I know you will need to know the unique Volunteers many times over and not just in a list view.  Best to address the structure now...

          Ideally, you should have:

          Volunteers table (which holds one each person who volunteers) with -
          VolunteerID (auto-enter FM serial number)
          F_Name (drop spaces in field names - it will cause you problems)
          L_Name ... etc

          Actions table (which holds one each of what you currently have)
          ActionID ( auto-enter FM serial number )
          VolunteerID ( holds the ID number of the volunteer this record belongs to)
          ActionDate ... etc

          Relate the two using = on VolunteerID.  This creates a one-to-many (1:n) relationship where one volunteer has many actions.  But I think you might still be missing something here.  Can one activity ever have more than one Volunteer assigned? 

          Please explain these actions themselves to help us understand your business need.  You may need an Activity table which would hold one each of the types of activities available, such as:

          Activities table
          ActivityID (auto-enter FM serial number)
          ActivityType (whether Adult activity or Child activity)
          Location ? or anything else unique to a specific activity

          This then might be the result of this type of structure

          Volunteers -< Actions >- Activities

          • 2. Re: Totally new to Filemaker and just getting started messing with a really basic database. The fields...
            uaykylie

            Thank you so much that answered my question and then some!  I had a feeling there was an issue with the way I was setting it up.  I will go back to the drawing board with a lot more confidence.

             

            Kylie