I have patient charts scanned as PDF files that have a SQL Primary Key used as the file name excepting the '.pdf' extension. I intend to load the PDF files into a MS SharePoint document library that I have created. I have defined other special metadata columns for this library such as
"Date Of Birth"
This information exists in a SQL table. My hope is to import this data into the document library and populate the correct metadata fields - but how is this done? If this were ASP.NET and I was using a grid I would try to use a JOIN query. Can anyone suggest the best approach ?
Would I have to use a third party control or maybe a bit of code in SPD?