Multi-Hop Portal Edit/Create

[mk500]

I am having difficulty getting a portal to allow me to create records, and also edit values.

I have a people table, and I'm trying to associate children with their parents in a second table called people_parents. I created a second occurrence of people, and made my relationships from people to people_parents to people_for_parents.

I then have a portal in a layout connected to people where I want someone to be able to create the parent record. I am able to make this work by pointing the portal at people_for_parents, and FileMaker automatically creates the join record in people_parents. The problem is that I have a couple fields from people_parents that also need to be modified. I am not able to do this using this portal (every row shows the same value when I try to enter data).

If I create an identical portal pointed to people_parent, then I can edit all the data, including the data in people_parent AND people_for_parent. Unfortunately, I cannot create new records in this portal.

Isn't there some way I could have a portal that combines both of these capabilities? To be able to create new records, and also edit them?

I created an example file, and included it. Thanks for any help.

Multi_Hop_Portal_Edit.fp7.zip

[mr_vodka]

Wow. Talk about tongue tied.

Portals are used to show records from a related table.

In your second portal example, you can create a record once you type something into your field, priority. You can not create a new record by typing into the name field because your relationship is based off the middle table of people_parents.

What are you trying to achieve, maybe there are better solutions than the way you have set up your tables now.

[mk500]

In your second portal example, you can create a record once you type something into your field, priority. You can not create a new record by typing into the name field because your relationship is based off the middle table of people_parents.

Aha! Thanks! That's what I was missing. I hadn't tried clicking in the priority field, and as you guessed, was trying only the name fields. Sometimes the solution is right in front of you -)

As far as what my solution is trying to accomplish, it's similar to this test file. I need to attach one or many guardians to a child. Guardians and children are both people records, so I'm creating a many-to-many relationship back to people. The second table occurrence allows me to do this. This portal makes it very easy for quick data entry and edits.

Thanks for your help.