Hello, I'm using ASP Runner 6.3.
I have 2 seperate sql databases on the same sql server.
One holds documents in Sharepoint which are scanned from a desktop scanner.
One column holds the links to the documents, for example "http://servername/document1.tiff"
My other database is the front end for an internet submit form. What I would like to do is as follows.
Create a column in the sql database table for the internet submit form which would connect to the Sharepoint database and pull the links from the one specific sharepoint sql table column to a column on my internet form submit database table and column using the list view.
That way the user could click the link to pull up the tiff document and add the data from the scan to the internet form submit database.
Is this possible?
Basic, one column in ASP Runner would hold a different database connection to populate the column.
Thank you for any imput.