> http://www.sinletter.com/ecommerceschema.gif Cool. The only thing I'd change or consolidate rather is your category, subcategory relationship. I'd go recursive 10 times out of 10. There are functions out there already for PHP like the one I implemented at http:test.kentfoster.us/sitemap.php or with SQL Server 2005, you have CTE's (common table expressions that have mad fast recursion algorithms). Access? Bah... Rob Smith LexJet rob.smith at lexjet.com http://www.lexjet.com (800)453-9538 (941)330-1210 Int'l (941)330-1220 Fax 1680 Fruitville Road, 3rd Floor Sarasota, FL 34236