Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / June 2005

Tip: Looking for answers? Try searching our database.

How to filter the Update option based on the user ID!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mandy O - 27 Jun 2005 19:51 GMT
  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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.