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.
Below is my database trying to do a portal - with the fields visible.
But when you go into Browse Mode, the portal isn't accessible and none of the fields show up.
Below you can see how I have defined the relationships.
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,