Ok, here is my scenario and here is the problem.
I have one custom list that has around 12,000 lines of data, but I would like to have several pages where the list is broken down into different areas. So one for Austria, one for Germany, one for the UK and so on. So I have made this by creating different views that filters on the individual countries. That’s fine.
Next step, I’ve created additional pages for each country and added the list as a web part and selected the view (it’s a datasheet view) that relates to that page. Fine, I can see just the Austria data on the Austria page. However, I would like the ability for users to be able to update the list while in the country page.
But that’s not possible. It seems to be a view only web part and no changes can be made to the list.
My other alternative is of course to create separate lists for each country but I would like to avoid and just maintain one central list as opposed to creating lots of separate lists.
Any thoughts?
I found the solution!
By editing the web part and selecting show “Summary Toolbar” it gives you the option to edit the list, rather than just view only. Hurrah!