Got a Categories Table and Products Table which are to hold Categories of Perfume so got lngCategoryID; strCategory; strDescription.
Products Table: lngProductID; lngCategoryID; strTitle; strSize; strDescription; curPrice.
I've confused myself where should I define whether it's for Men or Women ?
in the Categories table ? under strCategory example DKNY for Men
Any thoughts most appreciated.
This post has been edited by absta: 10 May 2006 - 02:18 PM