Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Using BDC data create Custom Field types?

  Asked By: Audrey    Date: Mar 11    Category: Sharepoint    Views: 2426

I have BDC application definition of 5 tables. I need pull each table data into one lookup column. How can we approach this?



1 Answer Found

Answer #1    Answered By: Cora Bradshaw     Answered On: Mar 11

You need a cascading listbox option. Thats definitely custom  code.

BDC can give you data  from a table  or multiple tables. Depends on the Finder method's statement. You need to filter on that data based on the selection made by some other input data. This is where the custom field  type comes in. Very custom.

The BDC can provide filters. These filters can be used with web parts if you are using the Business Data List web part.

Entities can be combined and associated to provide a relational model but again with the web parts.

Since you want a cascading listbox you're gonna have to build a custom field type. If you do it the dirty, non-reusable way it'll still take a several days to implement. There's a lot of moving parts here.

Custom field types  because they have code behind can do just about anything as long as it renders. This includes accessing the BDC using filters and associations. See Ted Pattison's book Inside Microsoft Windows Sharepoint Services 3.0 for an example on writing a custom field type. They are tricky! See Patrick Tisseghem's book Inside Microsoft Office SharePoint Server 2007 for an example on accessing the BDC.

Didn't find what you were looking for? Find more on Using BDC data create Custom Field types? Or get search suggestion and latest updates.