Sign in
Microsoft.com
 
SharePoint Products TechCenter
 
 
 
SharePoint Products TechCenter > SharePoint Products and Technologies Forums > SharePoint - Business Data Catalog > Business Data (BDC) fields not saved using Custom Forms
Ask a questionAsk a question
Search Forums:
 

AnswerBusiness Data (BDC) fields not saved using Custom Forms

  • Wednesday, November 04, 2009 2:59 PMDaveLee212 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Posting this here rather than in the BDC forum as I don't believe it to be a BDC problem....

    I have a list that we are going to be using to store custom complaints against projects.  The projects themselves are handled in an external SQL Server based application, so I have used the BDC to connect to this to retrieve a list of current projects.  I've created a new Business Data field on my list and can use it to specify the project the item relates to, that works fine.

    I also need to customise the New Item form, so that I can show only a limited number of fields and provide additional text to guide users when raising complaints.  I've done this in SharePoint Designer and it all works fine except that the Project Name selected for the Business Data field is never saved.  Interestingly, I have set it to also save an additional field from the BDC and it saves this additional field, but not the actual project name.

    In order to rule out any of my customisations, I created a new list for testing, taking the following steps:
    1. Create new list
    2. Specify new Business Data field, select my BDC application, using the field name "Project Name" storing the additional field "ProjectID".
    3. Create new list item, select the appropriate project name.  All items save correctly, including the Project Name selected and the related ProjectID field
    4. Create new page, insert Custom List form, link to Customer Complaints list, type = New Item.
    5. Browse to my custom new form on MOSS, fill in the details exactly as in step 3 the Save.  All fields are populated except for "Project Name" which shows as (blank).  Even the correct "ProjectID" related to the project I selected is saved, but no the "Project Name" field itself.

    Does anyone have any idea what might be causing this?  I can't see any reason that this should be "by design" so I'm hoping that there is something I have missed when creating the custom form.

    thanks

    Dave

    • Moved byMike Walsh MVPMVP, ModeratorWednesday, November 04, 2009 3:11 PMBDC q - not customization for sure. (From:SharePoint - Design and Customization)
    •  
     

Answers

All Replies