Two portal setup help
Short version of problem: I'd like to have two portals, for two related records, and be able to enter data into the second portal based on the current record of the first.
An over-simplification of the database setup is Things Acquired ---< The Thing ---<Details about Thing. Things Acquired has fields ID (auto incremented) and Date. The Thing has fields Record ID and Thing ID (auto incremented). The Thing is related to Things Acquired via ID/Record ID. Details has fields Thing ID, Detail ID (auto incremented) and Detail Info. Details about Thing is related to The Thing via Thing ID/Thing ID. Allow create/delete is enabled on all downstream relationships.
I have yet to figure out a way to put two portals, one for The Thing and one for Details about Thing, on a form and get the second to update along with the first. I can get the first to update the records fine. Each time I move to a new row on the portal a record is created. The second portal, however, keeps creating records based on info from the first record of the first portal. Meaning that I can enter 50 records in The Thing, and there will be 50 unique Thing IDs, but all records in Details about Thing will point to Thing ID #1.
What I want is that, after entering info in the second portal and moving to a new line on the first portal, the second portal saves the current record, creates a new record (based on the first portal's values), and clears the portal for new data entry.
After searching through the forum, and google, I'm fairly certain that there is a way to make this work; I'm just not sure how. Any pointers to a solution would be greatly appreciated.
I'm using FileMaker Pro 11.