If you turn on cascading deletes in the relationships area of Access,
you simply need to delete the 'master' record. Access will handle the
deletes on it's own. Of course, you'll need to join the tables in the
relationships "editor" to make it work :)
You can't use joins that way in a delete operation. You would need to
use seperate queries (if you aren't letting Access handle the cascading
deletes itself).
Jeff Beer
Senior Programmer Architect
Hydrogen Media, Inc
(727) 530-5500 x303
[EMAIL PROTECTED]
> -----Original Message-----
> From: Joseph Thompson [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 14, 2001 4:33 PM
> To: CF-Talk
> Subject: Cascading Deletes (Access)
>
>
> Having tried several variations I can't seem to convince
> Access to delete
> from multiple related tables... Is that even possible?
>
> ie:
> <cfquery datasource="forum" name="DeleteForum">
> DELETE *
> FROM
> Forums LEFT OUTER JOIN Messages ON Forums.ID=Messages.ForumID
> WHERE
> Forums.ID=15
> </cfquery>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
