<div>
Okay three lists LIST1, LIST2 &amp;&nbsp;LIST3<br />
<br />
LIST1 &amp;&nbsp;LIST2 are connected and are working lists<br />
BPID in LIST2 = ID in LIST1 (Connection)<br />
<br />
I also have LIST3 which shares a common filed with LIST1 &amp;&nbsp;LIST2 (Siebel ID)<br />
the problem here is that LIST3 gets recreated from scratch once per month, same format just recreated.<br />
<br />
From LIST1 &amp;&nbsp;LIST2 forms I need access to Total Spent &amp;&nbsp;Total Spent Date from LIST3<br />
<br />
- tried workflow, but does not seem to be a way to do a workflow that updates all records in LIST1<br />
- Since the file gets recreated each month I would lose the connection<br />
<br />
Need some solid advise on the best way to do this.<br />

</div>


Okay three lists LIST1, LIST2 & LIST3

LIST1 & LIST2 are connected and are working lists
BPID in LIST2 = ID in LIST1 (Connection)

I also have LIST3 which shares a common filed with LIST1 & LIST2 (Siebel ID)
the problem here is that LIST3 gets recreated from scratch once per month, same format just recreated.

From LIST1 & LIST2 forms I need access to Total Spent & Total Spent Date from LIST3

- tried workflow, but does not seem to be a way to do a workflow that updates all records in LIST1
- Since the file gets recreated each month I would lose the connection

Need some solid advise on the best way to do this.


<div>
<div class="content wysiwyg-content">
LIST1 contains parent records<br />
LIST2 contains child records<br />
<br />
LIST1 &amp;&nbsp;LIST2 are connected<br />
<br />
LIST3 is a list that contains several fields from enterprise systems but the DealID field would be shared across all three. <br />
<br />
My question is what woul be the best way to connect the data from LIST3 to LIST1 &amp;&nbsp;LIST2 after it is re-created each time...<br />
<br />
Thanks<br />
<br />
<br />

</div>
</div>


LIST1 contains parent records
LIST2 contains child records

LIST1 & LIST2 are connected

LIST3 is a list that contains several fields from enterprise systems but the DealID field would be shared across all three. 

My question is what woul be the best way to connect the data from LIST3 to LIST1 & LIST2 after it is re-created each time...

Thanks




List COnnection in SharePoint

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.