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.
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."
Your help and suggestions are GREATLY appreciated!
P@tty Ayers
Macromedia Evangelist
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
