Hello,

I have two tables in my ms access DB. One is Categories, the other is Products. If you delete Categories, the one to many relationship will remove all Products pertaining to the CategoryID, it will not however remove the 4 images associated with each entry. PRImage 1, 2, 3, 4.

I have made my form that will pass the CategoryID to the delete page which in turn will call the delete before record script, then delete the records and re-direct to the page of my choosing.

The page that deletes instead, is refreshing over and over again, trying to load or re-load something. The code is all pretty standard, nothing is redirecting or refreshing (that I can find out) What could be the cause of this? My guessing is that Dreamweaver can't delete anything that is not a Primary Key, and what I am using as a Unique ID is the CategoryID field that is in the Products table. If someone delete's the Category, I want all the products gone as well and their images.

Any ideas, or thoughts? Someone ran into this before?

Seriously, nobody has had a issue like this? I find this one hard to believe?? Any takers or did I dump some coin on software not sufficient for my needs?