I would like to know if information entered on a custom list can be transferred from one site to another list item on another site. Ideally the information from the original request would be able to be attached to the new list item so the new owner will have a history. Please let me know what you recommend on how to handle the following scenario:
1 - Customer submits a request on Site B (it is a subsite of Site A)
2 - Researcher does some research to determine which team will handle the request. Researcher will change the content type from Request to Research and adding search progress and history.
3 - Researcher makes a decision and needs to pass on the request to users of Sites C, D, E, F, or G (also subsites of Site A) on their site (they will not have access to Site B)
4 - Fields from original request must be able to be pulled into a global report that pulls data from sites A, B, C, D, E, F, G, etc.
So basically I need a way to get the original request information from Site B to a custom list on another site that currently use content types that were created in the browser (no InfoPath or SPD) and I'd like the Researcher to NOT have to create a form on the site it's getting transferred to and manually re-type the basic information submitted by the requester.
I thought InfoPath would be a possibility to save as an attachment and somehow import the base fields into the new site and attach the research history as an attachment, but I don't know if it this is possible (I have limited experience with InfoPath up to this point).
I welcome any suggestions that you have. I am currently on 2007 (hopefully upgrading in the next 6 months) and I have access to InfoPath and SharePoint Designer, but not to VB for custom code. I do not have access to the server admin functions and my company will not use any add-ons.