Re: How to setup a database table?

[jurotek]

@chrisburton, I know what you saying. In a real life if I was going to set up DB like this here’s how I would go about it. In your case tho is prolly going little overboard but I’ll show you anyways:

tblURL
URLID pk
URLDesc

tblArticles
ArticleID pk
URLID fk
ArticleCategoryID fk
ArticleName
ArticleDate

tblArticleCategories
ArticleCategoryID pk
ArticleCategory

That way I could query data by article category also

tblPages
PageID pk
ArticleID fk
PageNumber
PageURL