Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

BDC Business Data Field on Custom List Form

  Asked By: Bradley    Date: Jan 24    Category: Sharepoint    Views: 3683

I created a custom list form based off the EditForm.ASPX page in a
document library. All the fields work with the exception of the
Business Data field. Using the field directory, the values appear and
I can select the BDC value. However the BDC value does not save after
I click the OK button.

Has anyone run into this issue? I have seen other people with this
issue but no workaround or solutions. Hopefully you guys have some
ideas or a solution.



10 Answers Found

Answer #1    Answered By: Naimish Ranganekar     Answered On: Jan 24

The first place I would look would be to check whether the application
definition for the BDC is built to allow updates. Most are not and will
exhibit the kind of behavior you describe.

BDCs normally are written to access data  stored in 3rd party application
databases. Since the BDC accesses the data directly it bypasses all the
business logic built into the LOB application. This isn't normally a
problem when you are reading the data, but may be a big issue  when
editing the data. So most BDCs default to ReadOnly.

Answer #2    Answered By: Caleb Gordon     Answered On: Jan 24

I probably need to clarify, I dont need to write back to the BDC data
source, I actually only need the BDC values  for read only however I
need to save  the BDC value back into the list  item within the
document library.

Answer #3    Answered By: Christie Carlson     Answered On: Jan 24

But if you are using the field  Directory you are adding the BDC Field to
the Edit Form, not the BDC value. I suspect what you want is a
calculated field based  on the BDC Field.

Answer #4    Answered By: Dorothy Farmer     Answered On: Jan 24

Sorry, field  Directory as in "Picker" from the Business Data field or
People/Group field. The directory  icon next to the check mark.

Answer #5    Answered By: Jacklyn Burnett     Answered On: Jan 24

I'm afraid I'm not following. When you talk about creating a Custom
EditForm I assume you are doing this in SharePoint Designer. And that
you are getting the fields  from a DataSourceDetails Picker pointing at a
BDC DataSource. If that's true then you are adding the BDC field  itself
to the form, not a copy of the value.

Answer #6    Answered By: Breann Beach     Answered On: Jan 24

created  a custom  list form  using SharePoint Designer based  off the
default EditForm.aspx of a document library.

I have serveral metadata fields/columns created in the document
library that display on my custom form. One of the fields  is a
Business Data/BDC field. When I click  edit item, my custom forms
opens instead of the original EditForm.aspx page. When the custom
form opens, I can fill out my custom form, the BDC field  pulls values
from the BDC data  Source that is defined by my application
definition. However when I go to save  the list  item, the values  I
entered are saved with the exception  of the BDC field. The value
entered or selected using the "Picker" of the BDC field is not saved.

Answer #7    Answered By: Timothy Hall     Answered On: Jan 24

That's what I thought you were doing. When you pull the BDC field  from
the BDC data  Source into your custom  form you are pulling the BDC field,
not the value in the field. The problem is that at that point it exists
on the Edit form  and the BDC, but not in the list  itself. So when you
save the edit form it saves back to a combination of the list and the
BDC datasource. I think what you need to do is add the BDC field as a
calculated field to the list itself so that the value is pulled from the
BDC and stored in the list.(Not sure how to do that since I've never
tried). Or you need to add the field to the list as a lookup field to
tie it to a particular entry in the BDC. Either way, you need to do
something to the list itself and not just to the EditForm for the list
if you want the value available in other forms in the list.

Answer #8    Answered By: Ian Powell     Answered On: Jan 24

I think I am following you however I added a BDC field  to a standard
annoucement list  pointing to the same BDC source and the value I
chose from the "picker" was saved with the annoucement list item. It
has something to do with the custom  list form  that the Business Data
field will not hold the value saved.

Answer #9    Answered By: Osvaldo Winters     Answered On: Jan 24

What I am saying is that you need to do the same with the custom  list
that you did with the announcement list. Add the field  directly to the
list, not to the EditForm.aspx only. Then when you do your custom edit
form pull the field from the list  and not from the BDC.

Answer #10    Answered By: Kylie Gill     Answered On: Jan 24

Thats exactly what I did, and this is the issue  I am running into. I
first created  the field  on the document library  list.

Didn't find what you were looking for? Find more on BDC Business Data Field on Custom List Form Or get search suggestion and latest updates.