6 Replies Latest reply on Jan 28, 2016 12:57 AM by RyanAshton

    Problems with portals and related fields

    RyanAshton

      Hi guys,

       

      I am trying to make a database for estimates for clients.  I have decided the data into "Estimates" and "Estimate Data" because each Estimate will have a portal with line items.

       

      I can't get the portal to work.  I copied the format of the "Estimate" template that came with FileMaker and made some changes to try and make it work with my database.  The template allows you to enter line items right there in the Estimates view, even though it is actually entering the items in a related table.  I can't get mine to do that.

       

      Below is the example from the template and the "Item" field is selected, ready to receive data.

      Screenshot 2016-01-26 00.57.57.png

       

      Below is my database trying to do a portal - with the fields visible.

       

      Screenshot 2016-01-26 00.57.17.png

       

       

      But when you go into Browse Mode, the portal isn't accessible and none of the fields show up.

      Screenshot 2016-01-26 00.57.27.png

       

      Below you can see how I have defined the relationships.

       

       

      Screenshot 2016-01-26 01.06.20.png

       

       

      How do I get it to work so that I can enter records in a related table from a portal - preferably without using a button and instead just having the next portal row become available when data is entered into the previous portal row?

       

      Thanks in advance,

       

      Ryan