SQL Statement help please

[unclerico]

Hi, I am developing a feedback form for our intranet (using classic ASP). The primary use will be to have project managers give feedback on his/her team members periodically. The functionality that I have in it currently is to have the PM give the feedback, submit the form, the data gets inserted into the database and an e-mail gets sent to both HR and to the person being evaluated. The tricky part for me is in the e-mail I do not want all of the text that was just entered into the form to constitute the e-mail body, instead I would like to pass a link with the Unique ID of the evaluation. Since this is used in a multi-user envrionment I can't really just use the MAX function to get the newest entry in the database to throw out to them. Any ideas?? Thanks a lot

Here is the structure of my table:
Table Name: Swop
Columns & Data type:
Swop_Id - Int (PK, auto increment)
Swop_DT - DateTime (used to hold the date and time of evaluation)
Swop_FY - varchar (used to hold the Fiscal Year the review was done)
Swop_Reviewer - varchar (used to hold the reviewer name)
Swop_Reviewee - varchar (used to hold the reviewee name)
Swop_Strengths - varchar (used to hold the text entered for the Strengths area)
Swop_Weaknesses - varchar (used to hold the text entered for the Weaknesses area)
Swop_Opps - varchar (used to hold the text entered for the Opportunities area)

 

[amrita418]

Maybe you should get the max(swop_id) group by swop_reviewer?

Regards,
AA

 

[unclerico]

right on, I'll give that a try...thanks