You are here: Home > SharePoint > SharePoint Products

Microsoft SharePoint Products, Advice and Solutions

Enhanced Lookup

Fully certified for Windows Server 2008, Windows Server 2008 R2 and Microsoft .NET, the Ballard Chalmers Enhanced Lookup feature for SharePoint expands on SharePoint's existing Lookup column type by using SharePoint lists to store related information to provide developers and users of deployed SharePoint solutions with comprehensive, complex yet easy-to use lookup capabilities.

Although SharePoint has always had a Lookup column type to allow a column in a list to be based on the contents of another list, the standard lookup column type has many limitations and can only be used as a lookup from a single list in the same web site.

The Ballard Chalmers Enhanced Lookup takes things a lot further and supports:

  • Non-linking Lookup Field: A Lookup Field which does not provide a link back to the lookup list
  • Separate Value and Text Properties: A Lookup Field which can look up one column for the text to display in the selection drop-down and another column for the value to be stored - giving the ability to emulate a 'code/description' scenario where the user selects an item using the description but the item's code is stored in the list
  • Store Lookup Values as Simple Strings: A Lookup Field which stores its value as a simple string rather than the complex 'ID;#Title;#ID;#Title' pattern used by the OOTB Lookup columns - this allows for simpler manipulation of lookup values by subsequent processes
  • Sorted Lookup Values: A Lookup Field where values are always sorted alphabetically - no need to keep the source list in a sorted order
  • Cross-site Lookup: A Lookup Field which can access lists in any site within a Web App - works with multiple Site Collections using both Explicit and Wildcard Managed Paths
  • Filtered Lookups: A Lookup Field which can be filtered based on a selection in another Lookup Field - giving the ability to create 'Parent/child' or Cascading Lookups
  • Lookups across Permission Boundaries: A Lookup Field which can access values in a list for which the user does not have explicit permissions - giving the ability to use secure lists as lookups without compromising the security by granting read access to site members
  • Auto-load Column Values: A Lookup Field which automatically loads column values when only one selection exists - when combined with Filtered Lookup, gives the ability to automatically load subordinate column values when a selection is made in a 'parent' lookup

The Ballard Chalmers Enhanced Lookup is available for £500.

To discover more about our Microsoft SharePoint Server capabilities and experience and how we can help you through Microsoft SharePoint Consultancy, SharePoint website and intranet development, Microsoft SharePoint training and mentoring, SharePoint support and Microsoft SharePoint hosting services, visit our Microsoft SharePoint case studies or simply browse the links below.

SharePoint Case Study
SharePoint Case Study
Related links
Testimonial
"All the feedback I have had to date from my engineers is that your company has been 'a breath of fresh air'. Everyone is very pleased you are on board."

Sales and Marketing Manager, Computer Systems Engineering Ltd