.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Add subform to New, Edit, and View forms

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :SharePoint
I have two lists with related information: Projects and Tasks. I would like to edit the NewForm, EditForm, and ViewForm for the Projects list so that users can add, change, and view related tasks in a datasheet subform. I know how to do this in Access forms, but it seems there is no easy way to accomplish something similar using SharePoint lists and the SharePoint Designer. I have seen other posts, listed below. http://social.technet.microsoft.com/Forums/en/onlineservicessharepoint/thread/f803ee36-8853-4a73-8d10-1fc687a37781 This is not very helpful, for users would have to be jumping from one list to another and manually creating the relationships between projects and tasks. That is cumbersome. http://geekswithblogs.net/SoYouKnow/archive/2008/12/24/creating-a-sharepoint-list-parent--child-relationship---out.aspx This relates to what I need, but I guess there is something wrong with the steps, as I cannot get the parent form to set parameters for the subform. Has anybody been able to accomplish this?

View Complete Post

More Related Resource Links

Sharepoint Foundation - Create and deploy custom edit/view forms for external lists


Firstly, we are using sharepoint foundation so Infopath forms are not an option for us.

We have a Visual Studio sharepoint project which deploys a complete sharepoint site. The site contains a number of external lists and we want to be able to create customised view/edit forms for these lists and add them to our Visual Studio project so they can be deployed as part of the new site. The idea is that we can deploy the solution to a fresh site with a default set of forms which can then be customised for different implementations of the site.

Here's the steps we have been using to try and do this:

1. Deploy the base project (BDC) to the sharepoint site

2. Create external lists based on the BDC content types

3. Use Sharepoint Designer to create new edit/view forms for the lists and set these as the default forms for the list

3. Save the site as a template

4. Import the template into a new Visual Studio project and select the lists we require. This gives us a List Definition, a pages module (with element file), an elements file and a schema file (both for the List Instance).

5. We then add the contents of the imported project to our main solution as follows:

  • Create a new List Definition (including List Instance)
  • Copy the contents of the imported Elements.xml to the Elements file for our List Instance.

Sharepoint Foundation 2010 - How to control which fields are shown on new/edit/view forms for Extern


I have an external list which contains a DateTime field.  For the display I have added an additional string field to the BDC Entity , so i can display the date in whatever format is required.  But i still need the actual date field so a Date picker is rendered on the edit form.  How can I display the string field on the generated Display Form and the date field on the Edit Form.

I have tried adding the following to the field declaration (in the List schema) for the string field so that it's only shown on view forms, but that didn't work.   

  • ShowInDisplayForm="TRUE" ShowInEditForm="FALSE" ShowInNewForm="FALSE" ShowInViewForms="TRUE"

Am i missing something, or is this yet another 'feature' of external lists which looks like it should work but doesn't? 

I know i could create custom iew and Edit Forms manually t

Customizing the Insert/Edit Forms

Hi, I need to have 2 tables show in one webform(one-to-one relationship). I have tried customizing the Insert webform from the PageTemplates(creating the entity folder under CustomPages and copying the Insert page from PageTemplates), but it shows a lot of duplicate errors, e.g. The type GRIPS.Insert already contains a definition for DynamicDatamanager1, ScriptManagerProxy, etc... Can anyone tell me what I'm doing wrong? Thanks, CC

How to properly configure permissions so users can view, add, edit, and delete list items, but not w

I am trying to figure out how to properly setup security so that it can be configured at the top-level, and then inherited all the way through. Here is what I would like to do: Each user can view, add, edit, and delete list items - but, users cannot modify or delete web part pages. The only way I know how to do this is set Contribute from the top-down, and then go into each Site Pages library and set Read access. The problem is that I have 100 sites, and I was hoping there was a way I could set security at the top, and inherit downward. Rather than having to go into all 100 Site Pages library and set Read access. Is there a way to do this? Thanks in advance.

Edit in Datasheet view does not work on one SharePoint 2007 farm, works on another.

The ability to edit in datasheet view on one of our environments no longer works.  I've tried different client machines on different builds and regardless of the install every library, list, etc. when attempting to edit in datasheet view shows as read only.  Our other environments those systems work as intended with those same clients. I've searched all over and haven't found anything that helped.  Any ideas?

Edit in Datasheet View on List is not working

I have a list with simple column types like single line of text, Number, Hyperlink,  Picture, choice. When i edit the list in datasheet-view, below error is getting displayed. An unexpected error has occured. Changes to your data cannot be saved. For this error, you can retry or discard your changes. This error is occuring on edit certain rows/columns only. The view is having a simple filter condition. Could anyone check and suggest a solution/workaround for this ? Thanks in advance.      

Auto-fill Title and other fields from a data View edit menu

How do I Auto-fill Title and other fields in a list from a data View edit menu. The Title and other current data should transfer from the data view row being edit. Can anyone point me into the right direction how to accomplish this? Thanks. Mike  

Can edit, but can't view Word docs in web apps.


I'm having a very odd problem with the Word web app.  I can view some word docs on my sharepoint site, but when I try and view others I get the "... Unexpected Error" problem with others.  The ones where I get the error I can click the drop down and select "edit in web browser" and it works fine!  Very odd, these docs are in the same doc lib.  So, how can I edit, but not view?  Very strange and frustrating.....  Any one else see this before?

Also, I looked in all the logs and I don't see any extra infromation.  :(

Chad Gronbach

OOTB Approval Workflow SharePoint 2010 - Blank "Requested By" field appears in Task Item edit/view f



I am having a simple OOTB  approval worflow associated to the simple document library. Task is created when an document is uploaded to the library.  When I click the task item in task list, I see a blank field "Requested By"  right below the "Status" column and I am unable to understand from where this field is coming and how to populate this field. Any help would be great...

InfoPath Print View in web based InfoPath forms not printing


Hi All,

I am using InfoPath 2007 web based forms along with SharePoint 2007. I have set print views in all forms with proper formatting. But when I try to print a form, print view is not printed instead current view of infopath is printed. This behavior is happening in InfoPath Web based forms however in InfoPath client based forms I am successfully able to print a form with print view.

Can any body help me how to solve this problem ? 

Excel "View in browser" or "Edit in browser": Unexcpected Exception


Hey everybody

We are using Sharepoint 2010 (Enterprise), Office web apps is installed.

Powerpoint & Word web apps work (view or edit in browser).
When we click on an excel 2003 file we recieve the open in excel dialog (read-only / edit).

Wen we click on an excel 2007 file we get an unexpected exception.

I used the ULS viewer and the correlation id to retrieve the stack trace below:
System.NullReferenceException: Object reference not set to an instance of an object.  
 at Microsoft.Office.Excel.WebUI.XlViewer.OnInit(EventArgs e)   
 at System.Web.UI.Control.InitRecursive(Control namingContainer)   
 at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Exception follows on the heels of:
Name=Request (GET:http://bekrbsv313:80/sites/medical/_layouts/xlviewer.aspx?id=/sites/medical/Scrum/Sprint.xlsx&Source=http%3A%2F%2Fbekrbsv313%2Fsites%2Fmedical%2FScrum%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1)

does anybody have a clue?

I'm getting desperate :-)

Enabling Edit , delete and insert in Data view with linked sources


Hello ....


I create a data view in sharepoint designer 2007 that has linked sources (Join between two lists) ....


How can I enable edit, delete and insert links in this data view  ????.... taking in consideration that options available in data view properties appear in gray ...



Grid View edit



I have a grid view that does add, edit update and delete.  ( I draged the grid to the aspx page ) it is working. I would like to have the following : once I lick on edit, I open a form inside the grid view to edit the fields. How can I do that




How to edit WF Forms with Infopath - and where to save


I've not been trained in InfoPath 2010 and SPD 2010 but I have to quickly redo this workflow that got destroyed during our 2007 to 2010 migration.  I'm hoping this is an easy question for you guys to answer!

SPD creates xsn forms for my workflow for initiation and the various tasks.  If I click one of these, there is an option to edit it in Infopath.  It opens in Infopath, and I can make my edits easily enough (mostly text / visual changes) but then how do I get it to save the form back to the workflow?  When I go to save it, it's asking me where to save it and I'm just not sure how to make it relate to the workflow.  I had hoped it would automatically save back to the workflow but that doesn't seem to be the case.  

Please help!


MOSS 2007 Strange Problem with edit forms, content types and document library columns


I'm having a strange problem and have not been able to track down any useful answers over google.

I inherited a SharePoint site that I am now making some changes to.

I am having problems with one document library.  We had custom edit forms on this document library, which I was finding a pain to maintain so I reset them back to the site definition.  This edit form now shows only those fields that are associated with the Document content type (the only content type - I've deleted the others) on the document library.  There are other columns on this document library that are NOT associated with the content type that I would like to show on the edit form but they are not available when I try to add them to the content type via Settings > Document Content Type > Add from existing site or list columns.  The select columns from drop down is set to List Columns.  The Additional Authors column is just not there.

I CAN see this field on the all items view for the document library, it is there and populated with data.

Setting the Allow Managed content types radio button to NO does not have any impact on which fields are visible on the form- I still see those same fields that have been associated with the Document content type.

Has anyone else seen this or does anyone have any thoughts?? 

They will be muc

Unable to edit in Datasheet View


Myself and several other users try to edit cells in a datasheet view and often get the error:  "Edit control creation has failed. You cannot edit cells".  This is an intermittent problem. We are all running Windows7 and Office 2007. Any ideas what causes this?

Fine-grained User Permissions, create and view with restricted edit rights


I'm running a Sharepoint 2007 installation which is slowly being rolled out through the organisation. We have a group of calendars which are shared between 14 executive PAs. I've been asked to lock down the permissions so that whilst any of the users can add items, only the user who created the item can subsequently edit this. I thought I could handle this by creating a new permission level with create and view rights only, which does what it should, however the user can now no longer edit their own appointments either.

Is there a way that I can give the item creator specific permissions on their item by default?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend