So, I've created a join table to join my Facilities table to my Addresses table, but I'm having trouble making the relationship work. Essentially I want to be able to input different addresses (physical, mailing, etc.) for each facility from my Facility layout.
I've created the proper parent and foreign key fields in these three tables, linked them as relationships, and created the portal on my Facilities layout. But I can't figure out how to add the various addresses via the portal. In the past, I've always created records in both my parent tables and then used a drop-down list in the portal to select the field (value list) in the second parent table and this would populate the join table foreign fields at the same time.
But now I would actually like to create records (addresses) in the second parent table via the Facilities layout portal. How do I do this while also populating the key fields in these related tables?