I have a client who has 2013 SP and has 3 different site collections.
They have an infopath form that is used. However they require they need to get information from a different list in other site collections.
They have a PO approval form and IM (cost plan of project) approval. The PO and IM cost approval sit on different site collections.
"What we would also like the PO form to do is look at the PO list and SUM the costs of all the PO that are assigned the IM of the current PO that is being raised. So one look at the form when raising a PO you can select the IM it is for and it will populate the form with the total spend allowed for the IM and the total spend so far with POs for that IM. "
Unforunlety there SP system is a legacy setup due to older versions data restriction of 4GB per Site collection (so I am informed). So migrating data to another SC is not possible yet.
Can this be achievable, if so how?