FP2003 - DRW - Custom DELETE SQL

[Grahame]

Hi

I'm trying to delete records in an Access DB. I've added a DRW region on
page1 that lists all the records in the DB. I've created a <a> link that
incorporates the record ID as a querystring, and this links to page 2. On
page 2 I have a DRW with the following custom SQL

DELETE newsID FROM tblNews WHERE (newsID = '::newsID::')

I've tried various different versions of the above SQL, and the only thing
I've managed so far is to delete ALL the records at one time, not the
individual deletion I'm trying to achieve.

I've coded all this before in ASP but I'm trying to create a standalone site
for a friend, and I want to use the DRW as much as possible to save me
getting into custom coding.

Any help greatly appreciated.

Cheers

Grahame