AnsweredAssumed Answered

Duplicate Record + Related Portal Records

Question asked by MrsEaves on Dec 15, 2014
Latest reply on Jan 19, 2015 by philmodjunk


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.