Need Guidance For Cell Phone Store

Hi,

I'm trying to get this added functionality happening to Powerstore2 also.

I've revised the database and am now up to the next part:

Originally Said By: Eric Mittman

  Make a set of pages to admin the subcategories with DataAssist, you must ensure that you associate the subcategory with the main category.  

I've opened up the index page that resides in the admin folder, then went Insert > WebAssist > DataAssist > DataAssist Wizard

I have the following settings on the first page of the wizard:

Database
Connection: localhost
Table: Subcats
Key column: SubcatID

Template
Name: Admin
Editable region: MainContent

Pages
I have all pages ticked, ie. Results, Search, Detail, Update, Insert, Delete

Can you confirm that the above settings are correct and whether I need all 6 pages as outlined above?

You were saying that I must ensure that I associate the subcategory with the main category. How do I do this, i.e which settings refer to this in the wizard?

Also the remaining steps of the wizard, ie. steps 2 to 10 are not clear to me either as I don't know what was set for the other pages in the store, I can't copy the settings so that everything remains consistent. Can you tell me how to fill out the remaining parts of the wizard?

Thanks



Also for the benefit of others following along, I revised the products table by adding the following column:

`ProductSubcatID` int(11) NOT NULL,

See full products table below:

CREATE TABLE `products` (
`ProductID` int(12) NOT NULL auto_increment,
`ProductSKU` varchar(50) NOT NULL,
`ProductName` varchar(100) NOT NULL,
`ProductPrice` float NOT NULL,
`ProductWeight` float NOT NULL,
`ProductCartDesc` varchar(250) NOT NULL,
`ProductShortDesc` varchar(1000) NOT NULL,
`ProductLongDesc` text NOT NULL,
`ProductThumb` varchar(100) NOT NULL,
`ProductImage` varchar(100) NOT NULL,
`ProductCategoryID` int(11) NOT NULL,
`ProductSubcatID` int(11) NOT NULL,
`ProductUpdateDate` timestamp NOT NULL default CURRENT_TIMESTAMP,
`ProductStock` float default NULL,
`ProductLive` tinyint(1) default '0',
`ProductUnlimited` tinyint(1) default '1',
PRIMARY KEY (`ProductID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

I also created a `Subcats` table to store the subcategories:

CREATE TABLE `Subcats` (
`SubcatID` int(10) unsigned NOT NULL auto_increment,
`Subcat` varchar(20) NOT NULL,
`SubcatCategoryID` int(11) NOT NULL,
PRIMARY KEY (`SubcatID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

This new table also stores `SubcatCategoryID` as a foreign key.