SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have two related lists. I have a parent list and a child list, the child list has a column that stores the ID of the parent list. In the parent's EditForm I added a dataview of the child list, and filtered it by the parent's ID. This is working okay, but I would like to display the child list in a Datasheet view so that editing and inserting is faster. Is this possible?

share|improve this question

The datasheet view is difficult to work with in that regard. You'll probably need to make your child list a multiple item form. This will allow for each line item in the child list to be edited on the fly, not as conveniently as a datasheet view but faster than editing each item individually through the UI.

share|improve this answer
When you say "multiple item form" do you mean "inline editing" or something else? – Brandon Apr 11 '12 at 20:31
When you insert a DVWP into a page in SharePoint Designer, you have various options, single item display form, single item edit form, etc. One of them is Multiple Item Edit form and it does allow for inline editing within the DVWP. – Eric Alexander Apr 11 '12 at 20:39
I got this working, but not 100% happy with it. It wasn't quite as "fast" as the datasheet. But with the datasheet it seems impossible to set filtering and/or pre-fill columns. Thanks for the good suggestion though! – Brandon Apr 12 '12 at 18:58
Glad it was useful. The datasheet view is inflexible in that regard, it would be much easier if it weren't locked down. The alternative would be to roll your own display with something like jquery/jqueryui and get something ajaxy to post back the data. – Eric Alexander Apr 12 '12 at 19:29

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.