This content has been marked as final.
Show 1 reply
-
1. Re: SPRY ACCORDION as Dynamic Menu - Phase 1 - the table structure
(Purple_Edge) Nov 27, 2008 3:53 PM (in response to oicram)1. Yes. What third table would you need?
2. No & No.
You shouldn't be able to delete a category if it has products as children.
You should have tables..
Category
CategoryID (INT) - Primary Key, Auto number
CategoryName
etc
Products
ProductID (INT) - Primary Key, Auto number
ProductName
CategoryID (INT) - Foreign Key to Category
etc
If you change something in Category, NOTHING changes in Products.
