2 Replies Latest reply on Jun 1, 2009 3:00 PM by viandante

    portals (very beginner questions)

    viandante

      Title

      portals (very beginner questions)

      Post

      Hi all,

       

      I am just looking for an easy explanation about portals. I can't find anything useful on the web. Actually, I am just trying to have a portal that shows the fields of my first table.

       

      I created 2 tables, I did two relationships between them, I did the portal, but on the browse mode it displays nothing!!

       

        • 1. Re: portals (very beginner questions)
          mrvodka
            

          A portal is basically just a "window" to display the child records of your relationship. For example, lets say you have a table that stores company information and another table that stores employee information. For the sake of this example lets just assume that you are not storing any history etc so its a straight one to many relationship ( one company, many employees ).

           

          Now once you have a relationship created between the two TOs, perhaps based on CompanyID if you just put a related employee field on the Company layout, it will return the first related record's information. You can display all the related records by using a portal.

           

          So if you are on a layout based off a TO of the company, you can put a portal that displays all the related employees. Now if you are browsing Company ABC's record, you shoudl see all the related employees.

           

          Portals are only as good as their relationship that it is based on.

          • 2. Re: portals (very beginner questions)
            viandante
              

            Ok, really thanks Mr_Vodka.

             

            Now, I am a step further. I am trying to create multiple filter portal. That is, I create one global field and an option field. If I choose A, filemaker search what I write in the global field in the codes, if I choose B, filemaker search in the names.

             

            I thought that two global calculating field should serve, one to be related to the codes and the other one to the names. The two calculating field have this formula:

             

            CalculatingField1

            case(optionbutton="A"; If(IsEmpty(gFilter_txt); “0¶z”; gFilter_txt & ¶ & gFilter_txt
            & “zzz”))

             

            CalculatingField2

             case(optionbutton="B"; If(IsEmpty(gFilter_txt); “0¶z”; gFilter_txt & ¶ & gFilter_txt
            & “zzz”))

             

            Of course, this doesn't work...

             

            Ideas?