Saving a copy of a layout from a related table
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?