I'm trying to create a helpdesk system for customer service/support. The system is meant for internal users to record information while on the phone assisting customers. I'm very confused on how to appoarch this important part of my project. I want a user to be able to add a record and be able to add updates to that record. I dont want however, for another user to be able to delete information that he didn't add to the records. In other words, I want only the originator of the data to be able to remove their own data. I still want other users to be able to add their own data to that same record. I'm not sure how to prevent one user from manipulating data that they didn't create.

Please give me assistance on where to start. If you have other ideas on how to tackle this issue, please state it.

Thanks

If you have a username field in the database for the records that contains the username of the person who added the record, then on the page that displays the records you can have a "Delete record" button that is in a show region behaviour that only shows on the page if the current user is the same username as is in the username field of the record.
Assuming you are using the standard macromedia login.
<b>
&lt;% if Session("MM_Username" = rset.Fields.Item("Username".Value then %&gt;
THE DELETE BUTTON CODE
&lt;% end if %&gt;</b>

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

Found this prebuilt free ASP helpdesk system... thought you could grab it and pick it apart, grab some ideas on how they tackle similar issues:

LIBERIUM HELPDESK
www.liberum.org/

Also, their are some cheap $$ solutions out there - might be worth buying one to see how they approach the concepts. Hope this helps.

(DWMX|IIS5|Access2K|XP|ASP/VB)
*Connman21*
www.conncreativemedia.com

Dave, that is great advice! However, I'm not familiar with that ASP code string. I'm not familiar with sessions either. Do you know where I can hit a brief tutorial regarding sessions?
How do I create a session?

hi

You don't need to set a session variable in this case if you are using the standard log-in as DW does it for you.

If you mean how do you actually start a session you don't need to do that either as your server does that automatically whenever a user accesses your site.

As for a session tuorial, i have no idea off the top of my head but i'm sure there is one somewhere.

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
hi

You don't need to set a session variable in this case if you are using the standard log-in as DW does it for you.

If you mean how do you actually start a session you don't need to do that either as your server does that automatically whenever a user accesses your site.

As for a session tuorial, i have no idea off the top of my head but i'm sure there is one somewhere.

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Great explanation Dave, thanks. I learned what and how to use session variables.

LOL, your member description is great, "Total Freaking Member", hehe