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?
Add a comment
|
1 Answer
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.
answered Apr 11, 2012 at 20:22
-
When you say "multiple item form" do you mean "inline editing" or something else?– BrandonApr 11, 2012 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. Apr 11, 2012 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!– BrandonApr 12, 2012 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. Apr 12, 2012 at 19:29