duplicate record and related records from portal
I searched the forum but was surprised I couldn't find a post on this issue.
I have a table of rooms and a table of items of furniture. There is a portal on the room layout of related items of furniture that are located within each room. I want to create a button that duplicates the room and all of it's contents from the portal. I started writing a script but I may be making it more complicated than it needs to be.
The room number is a unique value so it will have to be modified before the new record can be saved.
What is the easiest way to do this?