1 Reply Latest reply on Jan 5, 2009 1:19 PM by TSGal

    Portal not working

    gregoryTan

      Title

      Portal not working

      Post

      I had created a file with two layout inside. This two layout are One Delivery Order and One Job Process Record. All this two layout is relationship

      with a field can Job No. And at the Job Process Record Layout I create a field call Invoice and with drop down list of COMPLETED, NOT COMPLETED and TO Bill. I also had another field call Billing and been set like below:

      Case ( Job No = Delivery Order::Job No: and Invoice = "Not Complete"; "To Bill" ; 

      Job No = Delivery Order::Job No: and Invoice = "Completed"; "Completed" ; 

      Job No = Delivery Order PEARSON::Job No and Invoice = "Completed"; "Completed" ;

      Job No = Delivery Order PEARSON::Job No ; "To Bill" ; 

       Job No  ≠  Delivery Order::Job No: ; "Not Complete" ;

      )

       

      All this work fine, only problem i have is that i create another layout with portal and a field with drop down list : Completed, Not Completed and To bill.  I set the relationship with the Job process record layout field: TO Bill.

       

      But they is nothing come out on the portal. Here i try to use the portal method to show only the data on TO Bill or Not Complete

       

      Is anyone can help.

       

      Thanks

      gregory 

       

        • 1. Re: Portal not working
          TSGal

          gregorytan:

           

          Thank you for your post.

           

          Can you tell me more about the two tables?  In order to reference the two files, they must be related.  What field(s) makes up the relationship?  Can you give me an example where this isn't working?

           

          TSGal

          FileMaker, Inc.