5 Replies Latest reply on Feb 18, 2010 11:54 AM by philmodjunk

    Avoid display name 2 times in the list

    mayor

      Title

      Avoid display name 2 times in the list

      Post

      Hello,

       

      I still develop grant system and have files as below;

       

      grant_no

      investigator_name 

      grant_type

      grant_research_title

      date_start

      date_end

      .....

      .....

       

      The situation is 1 investigator may have more than 1 grant. The

      grant data is input by grant_no, regardless the investigator_name

       

      So, when I make layout "List of the investigator", for those who have

      more that 1 grant, their name is display 2 times or based on the number

      of the grant they have.

       

      So, how I want to make just investigator name appear just once although

      they have more than 1 grant.

       

      TQ

       

       

        • 1. Re: Avoid display name 2 times in the list
          philmodjunk
            

          Can you post an example of how you want this to look?

           

          Something like this perhaps?

           

          Investigator Name : John Smith

            Grant 1 details

            Grant 2 details

           

          Investigotr Name : John Doe

            Grant 3 details

          • 2. Re: Avoid display name 2 times in the list
            mayor
              

            Let say I have 5 records;

             

            Investigator name    grant_type   

             

            John                      local

            John                      international

            Micheal                  international

            Sara                      local

            Joseph                   local

             

            from the records above, I want to make list of investigator.

            In the example above, we got 5 grants but only 4 investigator,

            because John has 2 grants.

             

            So, I just want the list of investigator, regardless how many

            grant they have like below;

             

            John

            Micheal

            Sara

            Joseph

             

             

            Second thing is I also want to make list like the example

            you gave,

             

            Investigator Name : John Smith

              Grant 1 details

              Grant 2 details

             

            Investigotr Name : John Doe

              Grant 3 details

             

            How, to do that, please advice me. 

             

            TQ

             

            • 3. Re: Avoid display name 2 times in the list
              philmodjunk
                

              To give you the report you want, make a summary report with Investigator Name : John Smith in a sub summary when sorted by investigator part and place the Grant details in the body.

               

              Here's a link to a simple tutorial on setting up summary reports that you may find useful:

              Creating Filemaker Pro summary reports--Tutorial

               

              To get a list of investigators without duplicates, you should set up a table where one investigator = 1 record and link this to your current table by an Investigator ID. A list from that table will then not have any duplicates.

              • 4. Re: Avoid display name 2 times in the list
                mayor
                  

                I have setup a table but don't know how to setup one investigator = 1 record.

                Where to setup this, in relationship diagram or using script?

                 

                Please help.

                 

                TQ

                • 5. Re: Avoid display name 2 times in the list
                  philmodjunk
                    

                  Pardon my short hand.

                   

                  What I meant by 1 record = 1 investigator, was that you create one and only one record in this table for each investigator.