# ASP - Database construction/ Query help

**URL:** https://forum.kirupa.com/t/asp-database-construction-query-help/165109
**Category:** programming
**Created:** [October 7, 2005, 7:35pm UTC](https://forum.kirupa.com/t/asp-database-construction-query-help/165109 "2005-10-07T19:35:39Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![burns](https://avatars.discourse-cdn.com/v4/letter/b/e9a140/32.png) [@burns](https://forum.kirupa.com/u/burns)
#### Post date: [October 7, 2005, 7:35pm UTC](https://forum.kirupa.com/t/asp-database-construction-query-help/165109/1 "2005-10-07T19:35:39Z")

</div>

Hi,

I have been trying to construct a Db for a article site that i am creating.

I have been advised to setup the following tables:

**table articles**  
articleid (pk)  
article title  
article text  
article date

**table sections**  
sectionid (pk)  
name  
\*\*  
table article sections\*\*  
articleid (fk)  
sectionid (fk)

This is because a article eg “cancer” can appear in more then one article section eg “Medication” and “Research” or in just one section.

**FIRSTLY** can some check to see if i have created the DB correctly and that the relationships are correct

[here](http://www.sofo.co.uk/projectdm/milroy.mdb) access db

**SECONDLY** i am trying to create a query that will select all articles in a specific article section when you click a url, eg articles.asp?ArticleID=1

this will display all articles in that relevent section.

Any help would be greatly received as im going round in circles atm.

many thanks