P@tty,
If you have the tables related, with 'cabins' as the "parent" table, you
cannot normally delete a 'cabins' record while there exist "child" records
in 'photos' or 'otherphotos' with the same key (cabinID).
You can use cascading delete in Access to do this. (As in "flows
downhill".) Or, you can first delete all the photos for that cabinID, and
subsequently delete the cabin record.
HTH.
Ben
-----Original Message-----
From: Andrew Tyrone [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 2:29 PM
To: CF-Talk
Subject: RE: Could Not Delete From Specified Tables
> -----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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
