I created a form with two views. One does the updates and searches,
whereas other one is used to enter new records.
Now the problem i have is-when i try to search the database based on let
say Qualificaion,I get the right results but if i try to add more information,
i can do that to each and every search results. However, i only want user to
see the results and update only his own record.
I published this form to a share point site and m not sure how to make the
form allow user to update only his own information. How can i make sure that
the login id (When logged on sharepoint site)matches the searched ID, which
further can be used to update the record.
Also, i am using SQL server 2000 to create infopath form and submit data.
Will appreciate any kind of help!
Alex [MSFT] - 27 Jun 2005 20:37 GMT
You need to create a web service to retrieve the user id of the current
logged in user. This article will get you started:
http://msdn.microsoft.com/library/en-us/dnwebsrv/html/httpsecurity.asp
Then, using rules for view switching, you can get the functionality that you
are looking for.
Good luck,
Alex @ Microsoft
> I created a form with two views. One does the updates and searches,
> whereas other one is used to enter new records.
[quoted text clipped - 13 lines]
> Also, i am using SQL server 2000 to create infopath form and submit data.
> Will appreciate any kind of help!