Re: Lookup column from a different site

{\rtf1\ansi\ansicpg936\deff0\deflang1033\deflangfe2052{\fonttbl{\f0\froman\fprq2\fcharset0 Georgia;}}
\viewkind4\uc1\pard\lang2052\f0\fs24 Hi Dave,
\par
\par Welcome! It is my pleasure to be of some assistance for you.
\par
\par In fact, the built-in field in Sharepoint doesn't support this scenario, the look-up column from other lists. So we will need to develop one web part or create one new list for this issue. This has been one product improvement idea and stored by product team which may be involved into the next version.
\par
\par For the web part, it is essentially one ASP.net server control. We could drag-drop this component at the sharepoint page directly. The Annoucement located at the WSS team site default.aspx page is the web part for Annoucement list. At the web part, we could grasp the user information from other list based on your scenario requirement and decide how to render the web UI. This is all done in your own code, which will be very free for you on the internal logic design.
\par
\par For example, for your requirement:"...only certain members of a particular area have access to, ..."
\par At the web part, we could check the logon user credential and then obtain the information based on this user's right level. If he is a portal admin, we could display all the information for him and for other users, only show these accounts within his permission range.
\par
\par These WSS sdk articles provide the information for you on the web part design:
\par Web Parts Overview
\par http://msdn.microsoft.com/library/en-us/spptsdk/html/smpxWebPartsOverview_SV01071436.asp
\par
\par Creating a Basic Web Part
\par http://msdn.microsoft.com/library/en-us/spptsdk/html/CreateABasicWP_SV01003709.asp
\par
\par Please feel free to let me know if any further question on this matter.
\par
\par Best Regards,
\par Wei-Dong XU
\par Microsoft Product Support Services
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par }