6 Replies Latest reply on Sep 1, 2013 8:35 PM by JennySemmler

    Disappearing Portal Row



      Disappearing Portal Row


      This happens periodically and I can't figure out why.


      Here is the setup:


      2 tables:

         #1 Customers




          #2 Transactions





       There is a 1 to many relationship between these two tables (transactions is the many).


      On a layout based ono Customers there is a portal based on Transactions.


      In the transactions portal are fields relating to transactions.


      Here is the problem:  When I enter data into the portal rows and then click out, the row goes blank.

      The fields are stored in the proper Transacitons table but the portal won't show it.


      I have checked the portal.  I have checked Allow Creation of REcords on Transactions.   


      What is going on???







        • 1. Re: Disappearing Portal Row

           <!--    [if gte mso 9]&amp;amp;gt;&amp;amp;lt;xml&amp;amp;gt; &amp;amp;lt;w:WordDocument&amp;amp;gt;   &amp;amp;lt;w:View&amp;amp;gt;Normal&amp;amp;lt;/w:View&amp;amp;gt;   &amp;amp;lt;w:Zoom&amp;amp;gt;0&amp;amp;lt;/w:Zoom&amp;amp;gt;   &amp;amp;lt;w:PunctuationKerning/&amp;amp;gt;   &amp;amp;lt;w:ValidateAgainstSchemas/&amp;amp;gt;   &amp;amp;lt;w:SaveIfXMLInvalid&amp;amp;gt;false&amp;amp;lt;/w:SaveIfXMLInvalid&amp;amp;gt;   &amp;amp;lt;w:IgnoreMixedContent&amp;amp;gt;false&amp;amp;lt;/w:IgnoreMixedContent&amp;amp;gt;   &amp;amp;lt;w:AlwaysShowPlaceholderText&amp;amp;gt;false&amp;amp;lt;/w:AlwaysShowPlaceholderText&amp;amp;gt;   &amp;amp;lt;w:Compatibility&amp;amp;gt;    &amp;amp;lt;w:BreakWrappedTables/&amp;amp;gt;    &amp;amp;lt;w:SnapToGridInCell/&amp;amp;gt;    &amp;amp;lt;w:WrapTextWithPunct/&amp;amp;gt;    &amp;amp;lt;w:UseAsianBreakRules/&amp;amp;gt;    &amp;amp;lt;w:DontGrowAutofit/&amp;amp;gt;   &amp;amp;lt;/w:Compatibility&amp;amp;gt;   &amp;amp;lt;w:BrowserLevel&amp;amp;gt;MicrosoftInternetExplorer4&amp;amp;lt;/w:BrowserLevel&amp;amp;gt; &amp;amp;lt;/w:WordDocument&amp;amp;gt; &amp;amp;lt;/xml&amp;amp;gt;&amp;amp;lt;![endif]    --><!--    [if gte mso 9]&amp;amp;gt;&amp;amp;lt;xml&amp;amp;gt; &amp;amp;lt;w:LatentStyles DefLockedState=&amp;amp;quot;false&amp;amp;quot; LatentStyleCount=&amp;amp;quot;156&amp;amp;quot;&amp;amp;gt; &amp;amp;lt;/w:LatentStyles&amp;amp;gt; &amp;amp;lt;/xml&amp;amp;gt;&amp;amp;lt;![endif]    --><!--    /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal      {mso-style-parent:&amp;amp;quot;&amp;amp;quot;;      margin:0in;      margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:&amp;amp;quot;Times New Roman&amp;amp;quot;;      mso-fareast-font-family:&amp;amp;quot;Times New Roman&amp;amp;quot;;} p      {mso-margin-top-alt:auto;      margin-right:0in;      mso-margin-bottom-alt:auto;      margin-left:0in;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:&amp;amp;quot;Times New Roman&amp;amp;quot;;      mso-fareast-font-family:&amp;amp;quot;Times New Roman&amp;amp;quot;;} @page Section1      {size:8.5in 11.0in;      margin:1.0in 1.25in 1.0in 1.25in;      mso-header-margin:.5in;      mso-footer-margin:.5in;      mso-paper-source:0;} div.Section1      {page:Section1;}     --><!--    [if gte mso 10]&amp;amp;gt; &amp;amp;lt;style&amp;amp;gt; /* Style Definitions */ table.MsoNormalTable      {mso-style-name:&amp;amp;quot;Table Normal&amp;amp;quot;;      mso-tstyle-rowband-size:0;      mso-tstyle-colband-size:0;      mso-style-noshow:yes;      mso-style-parent:&amp;amp;quot;&amp;amp;quot;;      mso-padding-alt:0in 5.4pt 0in 5.4pt;      mso-para-margin:0in;      mso-para-margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:10.0pt;      font-family:&amp;amp;quot;Times New Roman&amp;amp;quot;;      mso-ansi-language:#0400;      mso-fareast-language:#0400;      mso-bidi-language:#0400;} &amp;amp;lt;/style&amp;amp;gt; &amp;amp;lt;![endif]    -->

          "Here is the problem:  When I enter data into the portal rows and then click out, the row goes blank."


          Wow, I swear this has been explained to you here http://forum-en.filemaker.com/fm/board/message?board.id=FM-en-4&message.id=15088#M15088 ...


          What field are you typing into in the transactions portal?  If you are typing the CustomerID, that is incorrect and Comment explained it.  Create a new table layout of transactions and look at the actual data.  Is the CustomerID showing in the transactions record?


          If your relationship is from Customers::CustomerID to Transactions::CustomerID and you have 'Allow Creation...' on for the Transactions table, then typing into ANY Transactions field in the portal will create a new Transactions record and automatically insert THAT CustomerID into it.  Does that Customer have a CustomerID?  Don't type the CustomerID in the portal - it shouldn't even be showing. :smileyhappy:


          If your record is disappearing, it means that the Transactions record is not inheriting the CustomerID or ... you are replacing the customerID so it no longer relates.  Also make sure that the CustomerID is the same data type in both tables.
          • 2. Re: Disappearing Portal Row

            Above is the simple relationship between customers and transactions.  "Allow creation of records...." for Transactions is turned 'on'.


            In the Transaction portal there are no ID fields of any type.  ...


            .... and yet, despite the portal delete all rows when I click out of it, the data is being entered in the transactions table?


            For me, the  previous issue you linked to was about understanding the problems caused by putting the .fk in the portal row.   This situation HAS NO .fk in the portal row and yet it still does not work.  As you can tell I am confused by the failure of this simple setup to work.  (Yes, I have deleted and recreated the portal.  I have deleted the portal fields and re-inserted them....)  I don't know what to try next?  My sense is that I am missing something pretty fundamental.


            Thanks for your comments.



            • 3. Re: Disappearing Portal Row

              Do you have any auto-enter options turned on for the CustomerID.fk field in the Transactions table? It seems very weird that the entries are names. Isn't your  CustomerID.pk field in Customers defined to auto-enter a serial number?

              • 4. Re: Disappearing Portal Row

                Right you are.  It is weird that the .fk fields was a name. 


                In my usual 'I wonder if I can..." mode, I converted the .fk to a lookup into names.

                When I removed the lookup, everything reverted to normal in the portal.


                It seems like a strange reaction on the part of FM to respond to such a blunder.  (Not strange for me to make such a mistake though... :smileysurprised: )


                Thanks for noticing it.  I've been pulling my hair out all day on this one....

                • 5. Re: Disappearing Portal Row

                  synergy46 wrote:
                  It seems like a strange reaction on the part of FM to respond to such a blunder.

                  Well, it assumes you know what you're doing. And the method can be useful in some situations, e.g. rapid entry into a one-row utility portal.

                  • 6. Re: Disappearing Portal Row

                         This can occur if your relationships are right, but the field definitions are different - eg customer: CustomerID is TEXT and Transaction:CustomerID is a NUMBER. Hope this helps.