I have three lists.
One is a list with a project name as a description for a hyperlink field - Project name is unquie in this list (although not enforced by code)
The other two are lists with with a text field that hold project name - one holds many records for a given project, the other but one.
The BO wants to be able to archive all items for a project at once, and then be able to change their mind and unarchive them if needed. Is there a non .net code idea for doing this? I would happily consider a SPD workflow to do this if I could only think of one that wasn't ridiculous..
The requirements for this site are becoming increasingly demanding and I sure wish SP was a relational DB.
I think you should create custom timer job to move list item from your original list to archive list.
Here is the some reference link for your information
Of course, you can define some Expiration on your Information Management Policy. You can refer to the following link.
You said they are able to change their mind and un-archive them if needed, this is implement difficultly. So, you must develop custom code to reserve the data from your history list, then give back it to your list.
Well part of the problem is I would like to have one of the three lists control what happens to the other 2. So if they decide to archive an item from the one list, it seeks the records from the other two lists that correspond and archives them as well. And if they unarchive the list item, it unarchives the other two list items as well. I am pretty sure that without custom code this will not happen. But was hoping and wondering if there was a way to do it will SPD workflow actions.