Andy - Thanks for your response. (Still welcoming any help from others as
well..)
> 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.
Okay, I just checked and no, actually I didn't make photoID in the table
'photos' a primary key. I *did* make 'otherphotoID' in 'otherphotos' a
primary key.
Let me see if I am understanding you - should the two secondary tables, each
which have a 'cabinID' column, each have 'cabinID' as a foreigh key, and
neither should have a primary key?
And (forgive my ignorance) how do I make a foreign key? I'm looking in
Access's help files and a reference book, but haven't found it yet.
My original message is quoted below. Thank you again,
P@tty
[original message]
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."
>
>
>
> >
> > 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
