Question about Lists and Content Types

Question

Just wondering I created a List in MOSS 2007 where say each row has a title and a number associated with it.  So some sample tuples would contain ('Test 1', 45), ('Test 2', 67), ('Test 3', 190)... (strN, intM).  What I'm interested in knowing is after this list is created, can it used to fill in a site column choice column with the values in column 1 from the original List?   So a Content Type that contains this site column (which is filled with values from List), will know that if choice 'Test 1' is selected there is also additional metadata associated with 'Test 1'.  Does this make sense?

J

Answer 1

You may want to try creating a data view web part to mimic this functionality that doesn't exist:

http://www.endusersharepoint.com/2009/07/23/4-minute-screencast-join-view-of-sharepoint-lists/

There's my 4 minute screencast on how to create a "join view"

---

Laura Rogers, MCSE, MCTS
SharePoint911
http://www.sharepoint911.com/blogs/laura

Answer 2

Laura, thank you for the reply.  I think my answer is something simpler than your video.  Apparently there is a site column type of 'lookup', which seems to able populate its dropdown contents with the values in an existing List.  I know nothing about MOSS 2007 but looks like I learned something new and useful today.

J