Carlene:
here are the relationships created using the ps3_categories, ps3_productcategories. the products table is pretty strait forward so I haven't mapped it out.
ps3_categories:
CategoryID - primary Key, Auto Number
CategoryName - text, name of category
CategoryParent - foreign Key to CategoryID, for creating sub categories
ps3_productcategories - used to relate a product to its category:
ProductCategoryID - primary Key, Auto Number
CategoryID - Foreign key to ps3_categories.CategoryID
ProductID - Foreign key to ps3_products.ProductID
balexander389215:
in my response to Carlene earlier, I created Excel CSV files, you can use those if it is more convenient for you.
