Problems with portals and related fields

Discussion created by RyanAshton on Jan 25, 2016
Latest reply on Jan 28, 2016 by 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,