I have a table "Officials" with a portal to a join table. In the join table portal is a popup list linked to the "Properties" table (which in turn creates my join table of "Officials_Properties." Is there a way to duplicate an Officials record that would keep the popup value entries?
Put another way, Sen. X has oversight for Properties 1, 2, 3, through 25. When I enter a second Senator, my user doesn't want to have select all 25 properties again. They want them to be there already, and they just swap out the original Senator's name and contact info for the second senator.
If I duplicate the record, it does not carry over the 25 rows of data in the portal. I'm not sure this is possible.
Thank you in advance,