8 Replies Latest reply on Nov 9, 2009 11:54 AM by TSGal

    subject: one record with several identical fields

    LuísJ

      Title

      subject: one record with several identical fields

      Post

      <!-- [if gte mso 9]><xml> <o:DocumentProperties>   <o:Template>Normal.dotm</o:Template>   <o:Revision>0</o:Revision>   <o:TotalTime>0</o:TotalTime>   <o:Pages>1</o:Pages>   <o:Words>97</o:Words>   <o:Characters>558</o:Characters>   <o:Company>x</o:Company>   <o:Lines>4</o:Lines>   <o:Paragraphs>1</o:Paragraphs>   <o:CharactersWithSpaces>685</o:CharactersWithSpaces>   <o:Version>12.0</o:Version> </o:DocumentProperties> <o:OfficeDocumentSettings>   <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif] --><!-- [if gte mso 9]><xml> <w:WordDocument>   <w:Zoom>0</w:Zoom>   <w:TrackMoves>false</w:TrackMoves>   <w:TrackFormatting/>   <w:PunctuationKerning/>   <w:DrawingGridHorizontalSpacing>18 pt</w:DrawingGridHorizontalSpacing>   <w:DrawingGridVerticalSpacing>18 pt</w:DrawingGridVerticalSpacing>   <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery>   <w:DisplayVerticalDrawingGridEvery>0</w:DisplayVerticalDrawingGridEvery>   <w:ValidateAgainstSchemas/>   <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>   <w:IgnoreMixedContent>false</w:IgnoreMixedContent>   <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>   <w:Compatibility>    <w:BreakWrappedTables/>    <w:DontGrowAutofit/>    <w:DontAutofitConstrainedTables/>    <w:DontVertAlignInTxbx/>   </w:Compatibility> </w:WordDocument> </xml><![endif] --><!-- [if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="276"> </w:LatentStyles> </xml><![endif] --><!-- /* Font Definitions */ @font-face      {font-family:Cambria;      panose-1:2 4 5 3 5 4 6 3 2 4;      mso-font-charset:0;      mso-generic-font-family:auto;      mso-font-pitch:variable;      mso-font-signature:3 0 0 0 16777216 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal      {mso-style-parent:"";      margin:0cm;      margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:"Times New Roman";      mso-ascii-font-family:Cambria;      mso-ascii-theme-font:minor-latin;      mso-fareast-font-family:Cambria;      mso-fareast-theme-font:minor-latin;      mso-hansi-font-family:Cambria;      mso-hansi-theme-font:minor-latin;      mso-bidi-font-family:"Times New Roman";      mso-bidi-theme-font:minor-bidi;      mso-ansi-language:PT;} @page Section1      {size:612.0pt 792.0pt;      margin:72.0pt 90.0pt 72.0pt 90.0pt;      mso-header-margin:36.0pt;      mso-footer-margin:36.0pt;      mso-paper-source:0;} div.Section1      {page:Section1;} --><!-- [if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable      {mso-style-name:"Table Normal";      mso-tstyle-rowband-size:0;      mso-tstyle-colband-size:0;      mso-style-noshow:yes;      mso-style-parent:"";      mso-padding-alt:0cm 5.4pt 0cm 5.4pt;      mso-para-margin:0cm;      mso-para-margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:"Times New Roman";      mso-ascii-font-family:Cambria;      mso-ascii-theme-font:minor-latin;      mso-fareast-font-family:"Times New Roman";      mso-fareast-theme-font:minor-fareast;      mso-hansi-font-family:Cambria;      mso-hansi-theme-font:minor-latin;} </style> <![endif] --><!-- StartFragment -->

      Regarding Filemaker, I have this site with world news and each “story” has some tags attached to it, for instance, “dollar drops 2%” has the tags “dollar” and “economic crisis” attached to it; and so on. I don’t want to write two records,

      -- story: dollar drops; tag: dollar

      -- story: dollar drops; tag: economic crisis

      but only one

      -- story: dollar drops; tag: dollar; tag: economic crisis.

      How can I write only one record (in order to save time) instead of having to write two records? The layout would look like that

       

      story

      date

      tag

      tag

      tag

      tag

      tag

       

      Later I would like to have a list of all the stories in my website sorted by tag.

      Thank you for any help you can provide.

      <!-- EndFragment -->

        • 1. Re: subject: one record with several identical fields
          littledog
            

          I don't clearly understand question or your problem, but I suppose that you need to number tags and on layout don't show each tag field name.

          • 2. Re: subject: one record with several identical fields
            LuísJ
               Another example would be:<!-- [if gte mso 9]><xml> <o:DocumentProperties>   <o:Template>Normal.dotm</o:Template>   <o:Revision>0</o:Revision>   <o:TotalTime>0</o:TotalTime>   <o:Pages>1</o:Pages>   <o:Words>87</o:Words>   <o:Characters>498</o:Characters>   <o:Company>x</o:Company>   <o:Lines>4</o:Lines>   <o:Paragraphs>1</o:Paragraphs>   <o:CharactersWithSpaces>611</o:CharactersWithSpaces>   <o:Version>12.0</o:Version> </o:DocumentProperties> <o:OfficeDocumentSettings>   <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif] --><!-- [if gte mso 9]><xml> <w:WordDocument>   <w:Zoom>0</w:Zoom>   <w:TrackMoves>false</w:TrackMoves>   <w:TrackFormatting/>   <w:PunctuationKerning/>   <w:DrawingGridHorizontalSpacing>18 pt</w:DrawingGridHorizontalSpacing>   <w:DrawingGridVerticalSpacing>18 pt</w:DrawingGridVerticalSpacing>   <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery>   <w:DisplayVerticalDrawingGridEvery>0</w:DisplayVerticalDrawingGridEvery>   <w:ValidateAgainstSchemas/>   <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>   <w:IgnoreMixedContent>false</w:IgnoreMixedContent>   <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>   <w:Compatibility>    <w:BreakWrappedTables/>    <w:DontGrowAutofit/>    <w:DontAutofitConstrainedTables/>    <w:DontVertAlignInTxbx/>   </w:Compatibility> </w:WordDocument> </xml><![endif] --><!-- [if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="276"> </w:LatentStyles> </xml><![endif] --><!-- /* Font Definitions */ @font-face      {font-family:Cambria;      panose-1:2 4 5 3 5 4 6 3 2 4;      mso-font-charset:0;      mso-generic-font-family:auto;      mso-font-pitch:variable;      mso-font-signature:3 0 0 0 16777216 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal      {mso-style-parent:"";      margin:0cm;      margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:"Times New Roman";      mso-ascii-font-family:Cambria;      mso-ascii-theme-font:minor-latin;      mso-fareast-font-family:Cambria;      mso-fareast-theme-font:minor-latin;      mso-hansi-font-family:Cambria;      mso-hansi-theme-font:minor-latin;      mso-bidi-font-family:"Times New Roman";      mso-bidi-theme-font:minor-bidi;      mso-ansi-language:PT;} @page Section1      {size:612.0pt 792.0pt;      margin:72.0pt 90.0pt 72.0pt 90.0pt;      mso-header-margin:36.0pt;      mso-footer-margin:36.0pt;      mso-paper-source:0;} div.Section1      {page:Section1;} --><!-- [if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable      {mso-style-name:"Table Normal";      mso-tstyle-rowband-size:0;      mso-tstyle-colband-size:0;      mso-style-noshow:yes;      mso-style-parent:"";      mso-padding-alt:0cm 5.4pt 0cm 5.4pt;      mso-para-margin:0cm;      mso-para-margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:"Times New Roman";      mso-ascii-font-family:Cambria;      mso-ascii-theme-font:minor-latin;      mso-fareast-font-family:"Times New Roman";      mso-fareast-theme-font:minor-fareast;      mso-hansi-font-family:Cambria;      mso-hansi-theme-font:minor-latin;} </style> <![endif] --><!-- StartFragment -->

            There are 20 soccer players; each player has some attributes (there are 10 attributes: strong, fast, tall, smart, quick, good team player, good with the headers, etc.). I want to make a file for each one;

            player 1: attributes: strong , fast

            player 2: attributes: fast

            player 3: attributes: quick, good team player, good header

            etc

             

            the layout for each individual file would be

            player

            attribute

            attribute

            attribute

            attribute

            (ie, the field “attribute” would be repeated)

             

            At the end I would like to have a list, sorted by attributes:

            -- strong:

            player 1

            player 3

            player 5

            -- fast

            player 2

            player 3

            etc.

            <!-- EndFragment -->
            • 3. Re: subject: one record with several identical fields
              philmodjunk
                 You should store your "attribute" data in a second related table linked to your main table. If you are unfamiliar with this technique, you might want to look up "Portal" in the filelmaker help system as you will likely want to manage the viewing/editing of this data in a portal.
              • 4. Re: subject: one record with several identical fields
                LuísJ
                   Thanks for reply. I'm using a trial version of Bento 3.0.1. (suppose it's the same as Filemaker) I write "portal" in the help function of the menu and nothing appears....
                • 5. Re: subject: one record with several identical fields
                  philmodjunk
                     This is the filemaker pro help forum. Bento is quite different from Filemaker. I suggest you post your question to the Bento forum instead of here.
                  • 6. Re: subject: one record with several identical fields
                    TSGal

                    Luis J:

                     

                    Thank you for your post.

                     

                    Create a second Library that will hold the attributes.  Then, in your original Library, drag the Attributes Library from the Libraries pane onto your form to create a related data field into the Attributes Library.  At the bottom of this related field, click the second icon from the left ( "+" - plus sign) to add a record to the Attributes Library.  Continue to click the "+" icon to add attributes for each player.

                     

                    In the future, please post your question to the Bento forum at forums.filemaker.com.

                     

                    TSGal

                    FileMaker, Inc. 

                    • 7. Re: subject: one record with several identical fields
                      LuísJ
                        

                      .Thank you

                      Sorry for posting this subject on the Filemaker forum.

                      But just to finish the matter, and since you were kind enough to help me with your suggestion,

                      I did what you mentioned but now I would like to sort the information by attributes:

                      -- attribute (related data)

                      player

                      player

                       eg:

                      --quick

                      Paul

                      John

                      -- good defender

                      Paul

                      -- godd header

                      Frank

                       

                      How do I do it? In the grid only the players appear; the related data apears in the bottom...  Thanks a lot

                       

                      • 8. Re: subject: one record with several identical fields
                        TSGal

                        Luis J:

                         

                        At this time, Bento will not allow you to display related data in a table layout.  You would need to copy the related data information into a field in the current Library, that I'm well aware defeats the purpose of the related data.

                         

                        TSGal

                        FileMaker, Inc.