Ben - Thanks very much for this response. I have the feeling I've built
this database incorrectly, and I'm considering re-doing it. I will keep you
posted!
Appreciate your help,
P@tty
> 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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
