Can a multiple value “lookup” column be displayed as checkboxes in a SharePoint List?

Question

I have one list to store information about people, and another list storing a list of tasks each person should achieve. I'm trying to create a SharePoint view which allows users to enter/modify people, and also tick off the tasks that person has achieved - each row will list the columns from the "people", list, followed columns containing a checkbox for each task row in the "tasks" list.

We are using a hosted instance of SharePoint 2010 Foundation edition. Am from an ASP.net/C# background and have just got started on SharePoint 2010 within the past week, so don't mind getting stuck into SharePoint Designer or Visual Studio to create a custom Web Part if I have to :)

Thanks in advance for any advice given.

Chris

Answer 1

Check this link: http://www.sparqube.com/sharepoint-lookup-column/. It is for edit lookup values using checkboxes.

NOTE: This is a commercial product.

Answer 2

Take a look at the Extended Lookup Field available at Codeplex.

This project installs a custom lookup field, which allows the user to choose the item through a SharePoint 2010 popup.

Answer 3

What you're looking for is the built-in Datasheet View:

When looking at your list, select the 'List' tab (under 'List Tools' at the top), and click 'Datasheet View' (second from left). This will allow you to enter users in an Excel-like fashion.

Multi-value lookups are displayed as a multi-select checkbox list in the DataSheet View (once the cell is selected), which I believe will suits your needs.

Answer 4

The OOTB lookup column supports multiple values in the following UI:

But I think you can create your own column based on lookup and implement custom field control (http://msdn.microsoft.com/en-us/library/ff679964.aspx#bk_custfieldtype) where you will be able to get field value and render it as multiple check box. It's not so much work to do.