2 Replies Latest reply on May 7, 2009 10:36 AM by KIDO

    How to overcome auto-complete one line issue ?



      How to overcome auto-complete one line issue ?




      I have one field with 3 lines in it - company name, city and zips. How to make auto-complete working on the three lines simultaneously? 


      I tried making separate fields for everything different tables, relations, but it gets more and more complex and didn't work in the same as auto-field.


      Any ideas ? 

        • 1. Re: How to overcome auto-complete one line issue ?

          "...it gets more and more complex and didn't work in the same as auto-field."

          Yet your "auto-field" didn't work either right?


          Can you spell out in much more detail what you are trying to do here?


          Can you explain why you want all this disparate data to be in a single field?

          • 2. Re: How to overcome auto-complete one line issue ?
               <!-- [if gte mso 9]><xml> <w:WordDocument>   <w:View>Normal</w:View>   <w:Zoom>0</w:Zoom>   <w:PunctuationKerning/>   <w:ValidateAgainstSchemas/>   <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>   <w:IgnoreMixedContent>false</w:IgnoreMixedContent>   <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>   <w:Compatibility>    <w:BreakWrappedTables/>    <w:SnapToGridInCell/>    <w:WrapTextWithPunct/>    <w:UseAsianBreakRules/>    <w:DontGrowAutofit/>   </w:Compatibility>   <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif] --><!-- [if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif] --><!-- [if !mso]><object classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object> <style> st1\:*{behavior:url(#ieooui) } </style> <![endif] --><!-- /* 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-fareast-font-family:"Times New Roman";      mso-ansi-language:EN-GB;} @page Section1      {size:595.3pt 841.9pt;      margin:72.0pt 90.0pt 72.0pt 90.0pt;      mso-header-margin:35.4pt;      mso-footer-margin:35.4pt;      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:10.0pt;      font-family:"Times New Roman";      mso-ansi-language:#0400;      mso-fareast-language:#0400;      mso-bidi-language:#0400;} </style> <![endif] -->

            Hello Stanley, and welcome to the forum.


            I do apologise for the late post and for the lack of suggestions to your issue.


            Allow me to explain that FM creates an internal Value List based on the contents in the selected field to be used in auto-complete. However, if the field contains info separated by carriage returns, each piece of text before and/or after a carriage return will constitute a different or (better say) independent and unique value in that Value List. This means that each line in your field is a unique value in the list that FM refers to, and not the record contents.


            You can test this if you setup your field to display a Drop-down list and create a Value List to display values from that field. You’ll be able to see each line of your field as a different value in the list.


            I strongly recommend that you use separate fields for your Company Name, City and zips. It will be easier to manipulate data in future as your database grows.


            But…   If you really, really, really need to keep those values together in the same field and use of auto-complete, then I suggest that you use only 1 line and separate you info with commas as in “Company, City, Zip”. This way, the auto-complete will work for the whole line.


            Best wishes