12 Replies Latest reply on Sep 24, 2014 1:49 PM by kureted

    I CANNOT INSERT A PORTAL INTO MY FMP12 system

    kureted

      Hi all ,

       

      I am having extreme difficulty in inserting a portal into one of my layouts

      I think I am doing everything right

       

      I have a QUOTATION table

      I have an INVENTORY table

      I have set up a field in each which is the common field

      I have opened the relationship graph and jpined the 2 x tables together

       

      However , when I go back to the layout and try to insert the portal the portal minformation screen appears , but all of the

      relationships are greyed out , thius I cannot select any

       

      Is there something simple which I have ommitte to do ???

       

      Pls advise

       

      Rgds

        • 1. Re: I CANNOT INSERT A PORTAL INTO MY FMP12 system
          mikebeargie

          Take a screenshot of your relationship dialog between those two tables.

          1 of 1 people found this helpful
          • 2. Re: I CANNOT INSERT A PORTAL INTO MY FMP12 system
            keywords

            Re: "I have set up a field in each which is the common field".  Not sure what you mean by a "common field".  What you need is a primary key field in one table matching to a foreign key field in the other.

             

            Re: "all of the relationships are greyed out".  If the relationships are greyed out it is prbably because they are not properly established; you cannot set up a portal using an unrelated table.

             

            Do what Mike suggests and maybe someone will be able to assist.

            • 3. Re: I CANNOT INSERT A PORTAL INTO MY FMP12 system
              kureted

              Hi Mike ,

               

               

               

              screenshot of relationship dialog as follows .............

               

               

               

               

               

              The number of tables in the file as follows .........

               

               

               

               

               

               

               

              Kind regards

               

               

               

               

               

              Ted Lawrence   |   General Manager  

               

              Top Performers Joinery T/A Flair Cabinets       Granite Transformations

              Albury - Wodonga

               

              Kitchen Showroom & Design Studio :                   Cnr. Osburn & Hovell

              St., Wodonga , Vic , 3690

               

              Ph  02-6055 0100         Mob  0434-43 2478         Fax  02-6055 0155

              www.flaircabinets.com.au

               

              <http://www.flaircabinets.com.au/>

               

                                       ABN  99 069 589 448

              License No.                            VIC   DBU 5715

              NSW  13402 3C

               

              This email, including any attachments, is only for the intended addressee.

              It is subject to copyright, confidential and may be the subject of legal or

              other privilege, none of which is waived or lost by reason of this

              transmission.

               

                If the receiver is not the intended addressee, please accept our

              apologies, notify us by return, delete all copies and perform no other act

              on the email.

              • 4. Re: I CANNOT INSERT A PORTAL INTO MY FMP12 system
                kureted

                Hi ,

                 

                 

                 

                screenshot of relationship dialog as follows .............

                 

                 

                 

                 

                 

                 

                 

                The number of tables in the file as follows .........

                 

                 

                 

                 

                 

                 

                 

                 

                 

                 

                 

                Kind regards

                 

                 

                 

                 

                 

                Ted Lawrence   |   General Manager  

                 

                Top Performers Joinery T/A Flair Cabinets       Granite Transformations

                Albury - Wodonga

                 

                Kitchen Showroom & Design Studio :                   Cnr. Osburn & Hovell

                St., Wodonga , Vic , 3690

                 

                Ph  02-6055 0100         Mob  0434-43 2478         Fax  02-6055 0155

                www.flaircabinets.com.au

                 

                <http://www.flaircabinets.com.au/>

                 

                                         ABN  99 069 589 448

                License No.                            VIC   DBU 5715

                NSW  13402 3C

                 

                This email, including any attachments, is only for the intended addressee.

                It is subject to copyright, confidential and may be the subject of legal or

                other privilege, none of which is waived or lost by reason of this

                transmission.

                 

                  If the receiver is not the intended addressee, please accept our

                apologies, notify us by return, delete all copies and perform no other act

                on the email.

                • 5. Re: I CANNOT INSERT A PORTAL INTO MY FMP12 system
                  keywords

                  Whew!  A quick look at the screenshots suggests there might be more issues that should be adressed than just the one you've posted—4,000 fields in a table looks like bad design.

                   

                  To get to the issue at hand, though:

                   

                  You appear to be using as a join field, a field (appliance type) that doesn't instantly suggest itself as a unique record identifier. I suggest you consider the following:

                   

                  1.     Add a recordID field to the inventory table using, say, a serial number, set it to autoenter for all new records, and populate it for all existing records using the Replace function.

                  2.     Add an inventoryItemID field to the quoting table and use these two fields to create the relationship between the two tables.

                   

                  You might also consider posting a copy of your file so that I and others can take a closer look and offer more specific advice.

                   

                  PS. There's no need to post the same thing twice.

                  • 6. Re: I CANNOT INSERT A PORTAL INTO MY FMP12 system
                    MSNThomas

                    Is your layout based on the same Table Occurance as the one you created the relationship with?

                    • 7. Re: I CANNOT INSERT A PORTAL INTO MY FMP12 system
                      kureted

                      Hi ,

                       

                       

                       

                      yes , as far as I am aware

                       

                       

                       

                      rgds

                       

                       

                       

                      Ted Lawrence   |   General Manager  

                       

                      Top Performers Joinery T/A Flair Cabinets       Granite Transformations

                      Albury - Wodonga

                       

                      Kitchen Showroom & Design Studio :                   Cnr. Osburn & Hovell

                      St., Wodonga , Vic , 3690

                       

                      Ph  02-6055 0100         Mob  0434-43 2478         Fax  02-6055 0155

                      www.flaircabinets.com.au

                       

                      <http://www.flaircabinets.com.au/>

                       

                                               ABN  99 069 589 448

                      License No.                            VIC   DBU 5715

                      NSW  13402 3C

                       

                      This email, including any attachments, is only for the intended addressee.

                      It is subject to copyright, confidential and may be the subject of legal or

                      other privilege, none of which is waived or lost by reason of this

                      transmission.

                       

                        If the receiver is not the intended addressee, please accept our

                      apologies, notify us by return, delete all copies and perform no other act

                      on the email.

                      • 8. Re: I CANNOT INSERT A PORTAL INTO MY FMP12 system
                        MSNThomas

                        Well, if it's not then that is why you aren't seeing the table you want.  Go into edit layout mode, under the "Layouts" menu go to "Layout Setup..."  and make sure the "Show records from:" option shows the right TO.

                         

                        If I understand what you are doing it should be "Inventory6". Otherwise it is the "LU appl details portal"  TO

                        • 9. Re: I CANNOT INSERT A PORTAL INTO MY FMP12 system
                          kureted

                          Hi ,

                           

                           

                           

                          thanks for your email

                           

                           

                           

                          The portal ( which works in my FMP5.5 solution ) is as follows ..........

                           

                          The appliance types are on a drop down menu in the PreOrder drawers Desc

                          Portal field

                           

                          When the appliance type is selected from the drop down list the portal is

                           

                          populated with all of the appliances in that category

                           

                           

                           

                           

                           

                           

                           

                           

                           

                          An example of when APPL Rangehood is selected , all of the rangehoods in the

                          INVENTORY TABLE appear

                           

                          I have a match field in each of the appliances which specifies if it is a

                          cooktop , rangehood , oven etc

                           

                           

                           

                           

                           

                           

                           

                          An example of when APPL Oven is selected , all of the OVENS in the INVENTORY

                          TABLE appear

                           

                          I have a match field in each of the appliances which specifies if it is a

                          cooktop , rangehood , oven etc

                           

                           

                           

                           

                           

                           

                           

                          THIS IS MY APPLIANCE QUOTE layout on the QUOTATION TABLE ( FMP12 )

                           

                          I have indicated where I want the portal to be , I want the displayed field

                          from the

                           

                          INVENTORY table to be as above

                           

                           

                           

                           

                           

                           

                           

                           

                           

                          BELOW is my FMP12 relationships graph

                           

                           

                           

                           

                           

                          Is this information of any use ??

                           

                           

                           

                          Pls advise

                           

                           

                           

                          rgds

                           

                           

                           

                          Ted Lawrence   |   General Manager  

                           

                          Top Performers Joinery T/A Flair Cabinets       Granite Transformations

                          Albury - Wodonga

                           

                          Kitchen Showroom & Design Studio :                   Cnr. Osburn & Hovell

                          St., Wodonga , Vic , 3690

                           

                          Ph  02-6055 0100         Mob  0434-43 2478         Fax  02-6055 0155

                          www.flaircabinets.com.au

                           

                          <http://www.flaircabinets.com.au/>

                           

                                                   ABN  99 069 589 448

                          License No.                            VIC   DBU 5715

                          NSW  13402 3C

                           

                          This email, including any attachments, is only for the intended addressee.

                          It is subject to copyright, confidential and may be the subject of legal or

                          other privilege, none of which is waived or lost by reason of this

                          transmission.

                           

                            If the receiver is not the intended addressee, please accept our

                          apologies, notify us by return, delete all copies and perform no other act

                          on the email.

                          • 10. Re: I CANNOT INSERT A PORTAL INTO MY FMP12 system
                            keywords

                            Ref your image011:

                             

                            If no relationships are listed in the "show related records from:" dropdown in the portal setup dialog, it almost certainly means that the table this layout is based on is the wrong table. Fix this and you should be right.

                            • 11. Re: I CANNOT INSERT A PORTAL INTO MY FMP12 system
                              MSNThomas

                              In Image11 it looks like the TO list starts scrolled way down near the bottom, which is a very annoying trait of filemaker's.  Related TOs will be at the top, so forgive me for asking but have you scrolled up to the top of the list?

                               

                              Except now I see that the LU appl details portal is in the list grayed out, which means your layout must be based on a Table Occurance from another group.

                               

                              Go to the layout edit mode, go to the "Layouts" menu, and under "Layout Setup..." make the "Show records from:" be said to the appropriate TO.

                              • 12. Re: I CANNOT INSERT A PORTAL INTO MY FMP12 system
                                kureted

                                Hi !!

                                 

                                 

                                 

                                I have finally worked it out !!

                                 

                                 

                                 

                                You are very correct , the TO which contains the Appliance Quoting Layout is

                                the first one ( QUOTING ) which is at the top of the graph relationship page

                                 

                                 

                                 

                                I joined the appropriate fields & presto the PORTAL is visible & working

                                beautifully

                                 

                                 

                                 

                                THANK YOU TO ALL WHO HAVE HELPED ME ON THIS MATTER

                                 

                                 

                                 

                                It is most appreciated

                                 

                                 

                                 

                                Kind Regards from AUSTRALIA

                                 

                                 

                                 

                                Ted Lawrence   |   General Manager  

                                 

                                Top Performers Joinery T/A Flair Cabinets       Granite Transformations

                                Albury - Wodonga

                                 

                                Kitchen Showroom & Design Studio :                   Cnr. Osburn & Hovell

                                St., Wodonga , Vic , 3690

                                 

                                Ph  02-6055 0100         Mob  0434-43 2478         Fax  02-6055 0155

                                www.flaircabinets.com.au

                                 

                                <http://www.flaircabinets.com.au/>

                                 

                                                         ABN  99 069 589 448

                                License No.                            VIC   DBU 5715

                                NSW  13402 3C

                                 

                                This email, including any attachments, is only for the intended addressee.

                                It is subject to copyright, confidential and may be the subject of legal or

                                other privilege, none of which is waived or lost by reason of this

                                transmission.

                                 

                                  If the receiver is not the intended addressee, please accept our

                                apologies, notify us by return, delete all copies and perform no other act

                                on the email.