I have a Sharepoint document library. I have a project database (project number,project name, project manager etc.) this information needs to be tagged to multiple documents. I want to use the project number as a lookup field (site lookup doesnt work well...)
Anyone have a suggestion on how to best achieve this?