However, I need a 'vacancies administration section' where consultants can amend jobs - say they realised they made a mistake after posting - and where they can remove vacancies once they are no longer open. I've created a page which lists the vacancies in summary form, and have put two buttons next to each - amend, and delete - but now I don't know how to get them work. I'd put up a page similar to the 'post a job' one and populate it with the info originally posted, but how can I be sure when it posts back to database it overwrites the job and doesn't just create another?

And what about the delete? Where on earth do I start with that?

If anyone's interested, you can see what I mean on the test site www.vbcontracts.com if you click on the admin link bottom left of the screen. Oh you'll need a name and password (thanks spooky!) and 'paul' and 'paul' will get you in.

Thanks in advance

------------------
***born to be wild***

Did the delete stuff from a link on this site using a 'deleterecord.asp' with the following in the SQL Statement box:

DELETE DISTINCTROW Job_reference
FROM Vacancies
WHERE (Job_reference='::Job_reference::')

Where the Job_reference had been passed from a delete.asp page. It's a bit clumsy, but it works.

You can still see it on the site per previous post if you're interested.

Thanks again to outfront.net for the info...

------------------
***born to be wild***