Here's what I have so far...
1. I have a document list in MOSS 2007.
2. Each document in the list
may be sent to an external system for further processing. This was done by adding a custom feature to the document libraries actions menu in SharePoint.
3. The external system uses it's own SQL Server database. A table in this database references the SharePoint document’s GUID. Additional
columns in the table are updated during external processing data such as status.
The problem I'm trying to solve is this:
1. I would like the see the external processing status for a document in the original SharePoint document list. This status will change and needs to be updated for each document automatically.
I tried setting up a business data column in the document list. I created the XML definition of the external SQL Server table using the MOSS 2007 SDK and imported the definition. I added the business data column to the list
View Complete Post