Duplicate Record + Related Portal Records
I have a database of products. The main layout contains two portals of related fields (features and technologies). All records are related through a unique product ID (see image below of relationships).
I would like to create a script that would duplicate the entire set of related fields for one product. Ideally I would place a button on the ProdutSerialNumb layout with a script attached. The script would duplicate that record and generate a new unique ID, then would find all associated records, duplicate them and apply that new ID to them.
Bonus points if it can also display a dialog box to allow the user to modify a specific data point that shows up on all three tables, such as product name.