Sub Catagories and recordsets
I'm trying to add categories and sub catagories to an ecommerce site. I'm pretty sure the tables in the database are correct from following the blue_sky_music examples. I've been following various threads (showthread.php?t=2785&highlight=modify+product+insert+update+pages) trying to fathom the correct way to customise DA to add Sub Categories. I'm even reading "Database Designs Solutions" by Rod Stephens and MySQLs Work Bench as recommended to get up to speed but I'm running out of time on what should be a simple task - getting the insert and update pages configured correctly. I've created the required files in DA but when I add and change the recordsets I either get multiple entries in the lists on these pages and/or it refuses to see the current record correctly in the details page. Is there anywhere to follow how to configure the insert and update pages and update the server record behavior?
Using latest DA, eCart, CS4, PHP on a Linux server upoaded from an Intel Mac running OS X (10.5.8)