"I need to show 2 lists (contracts + Finance ) in the same view."
Below I've 2 custom lists:
1-Custom List "Contracts" and
2-Custom List "Finance".
Both were in Excel and I imported to SharePoint via import XLS feature. Now the idea is that we show the data of both lists in 1 view. The key field is ContracID in both lists.
Contracts list is static they can add/update/delete etc via SharePoint.
Finance Lists should be every 2 days (3 x p/week) refreshed. I mean, the Finance list will be deleted physcially and re-created via "Import XLS", because the amounts are changed everytime. Finance data is coming from other System. so they don't or may not change the Finance lists either in sharepoint.
I did:
I created the same "Finance list fields" in "Contracts list" and used eventreceiver which works fine, but when I delete the Finance List and re-create the Finance list for import, the Eventreceiver is not working. Copy/Paste records is working, but I only copy 30-40 items and I have almost 2000 items in Finance list.
So how can I show the 2 lists in the same view. They may only edit the Contracts fields and not the Finance fields. I think I can fix this with permissions.
Please advice how to fix this. Please do not send me just 1 word or a link, but also specify in human words or explain a bit which helps me for further googling.
List Contracts
ContractID
Name
Adres
... and other fields
List Finance
----------------
ContractID
Amount1
Amount2
Amount3
... and other fields