AnsweredAssumed Answered

Saving a copy of a layout from a related table

Question asked by JeffBroderick on Jun 29, 2014
Latest reply on Jun 30, 2014 by TSGal

Title

Saving a copy of a layout from a related table

Post

     I've tried to find an answer but so far haven't been successful. I'm still kind of a newbie.

     I have a table that randomizes various ingredients for dinner ideas and a related table that has a layout to save the identical info.

     My dilemma is that when I hit the save button where I duplicate the info in a saved layout, I want to reset the original layout so there are no existing recipe combos but KEEP the saved one.

     Because I'm using a foreign key on the Saved layout to lookup the same items, whenever I delete the original, it deletes the saved one.

     How can I save to another layout, delete the original but keep the saved one?

Outcomes