Very cool! Thanks
That sure makes life a little simpler :-)
> 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
