> -----Original Message-----
> From: P@tty Ayers [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 3:26 PM
> To: CF-Talk
> Subject: Could Not Delete From Specified Tables
>
>
> Ok, you all helped me tremendously this morning, so I'm hoping someone can
> point me in the right direction on this new problem.
>
> I've created a Delete Record page, but when I test it, I get an error
> message simply saying "Could not delete from specified tables."
> Any ideas at
> all why?
>
> A little information on the database:
>
> It's in Access2000 and has three tables, 'cabins', 'photos' and
> 'otherphotos'.
>
> cabins has cabinID as its primary key, each rental cabin is a record.
>
> photos also has cabinID as a primary key, and I created a relationship
> between the two tables using the two cabinID fields.
Do you mean you have a primary key called photoID in this table as a primary key?
cabinID in this table should be a foreign key, related to the cabins table.
>
> otherphotos has otherphotoID as its primary key, and each record
> is a photo,
> each associated with, again, cabinID. cabins is related to otherphotos by
> the cabinID column.
>
> Both of the relationships are one-to-many, and I have checked "Enforce
> Referential Integrity" and "Cascade Update Related Fields."
Are you trying to delete a cabin record? It should work then, and also cascade delete
all records that contain a foreign key in the other photo tables, based on how you say
you have it set up. If you DO have the cabinID set as a primary key in the photos
table, this could be your problem.
>
> Your help and suggestions are GREATLY appreciated!
>
> P@tty Ayers
> Macromedia Evangelist
- Andy
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists