AnsweredAssumed Answered

subject: one record with several identical fields

Question asked by LuísJ on Oct 17, 2009
Latest reply on Nov 9, 2009 by TSGal

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 -->

Outcomes