Hi everyone, complete new user here with, what is to me, a complex problem. Sorry if this is the wrong location for this question, and please excuse incorrect verbiage, I'll try to explain what I mean the best I can.
Briefly:
-I currently have a database built to compile/track/compare data that is entered via an InfoPath form that is published to a SharePoint server.
-I need to display the table the data is being sent to, as a list on the SharePoint. (or if not a list, whatever is appropriate)
-I need said SharePoint list to auto-update everytime new data is added to the database table via the InfoPath form.
(in other words: a user that does not have access to the database, opens the form from the SharePoint, enters and submits the data to the Access table, which is displayed or copied to the SharePoint list - without me having to go in the database and transfer/copy the record)
I understand how to link a SharePoint list, and have, but I cannot figure out how to automatically transfer the data from the access table, to the "SharePoint table" (that is linked list) without manually running a query or the like.
Hope this makes sense, and I appreciate any help that anyone can offer. Thanks.
Briefly:
-I currently have a database built to compile/track/compare data that is entered via an InfoPath form that is published to a SharePoint server.
-I need to display the table the data is being sent to, as a list on the SharePoint. (or if not a list, whatever is appropriate)
-I need said SharePoint list to auto-update everytime new data is added to the database table via the InfoPath form.
(in other words: a user that does not have access to the database, opens the form from the SharePoint, enters and submits the data to the Access table, which is displayed or copied to the SharePoint list - without me having to go in the database and transfer/copy the record)
I understand how to link a SharePoint list, and have, but I cannot figure out how to automatically transfer the data from the access table, to the "SharePoint table" (that is linked list) without manually running a query or the like.
Hope this makes sense, and I appreciate any help that anyone can offer. Thanks.
