Lookup with Picker Data Type for a SharePoint List

While researching the issue I mentioned in my previous post, I ran across this neat thing at CodePlex: http://www.codeplex.com/lookupwithpicker/Wiki/View.aspx.  Here’s the brief description: Microsoft Sharepoint Server 2007 lookup control with element picker for custom list.This control is useful if you need to choose lookup data from large lists. This control supports single and multi select…

string;# Before Values in a SharePoint List’s Lookup Column Based on a Calculated Value

I’ve seen lots of posts discussing this, but no workarounds.  Here’s the situation: One list (List 1) contains a list of values that are calculated (say ColumnC = ColumnA & ColumnB) Another list (List 2) uses ColumnC above as a lookup for one of its columns If you go into Datasheet view for List 2,…

Counting Subsets of Items in a Data View Web Part (DVWP)

I’ve posted about this application before. It helps my client manage their inventory of sports tickets which they can use with their clients and vendors.  They have a regulatory reporting requirement to maintain information about who uses the tickets and what their relationship is. In this case, we wanted to be able to count the…