references the lCategoryID primary key in the same table<BR>szCategoryName varchar(100)<BR><BR>So for example you could have something like this to desribe the relationship: Electronics ...