ASP - SQL / Advice Please!

[Tommyj]

Hiya Everyone,

I hope someone can help me out with this!

I'm devloping a product database, and have hit a brick wall. I was
hoping some experts in here might be able to give me a little advice
as I think I'm missing something.

I'm using ASP and an Access 2000 DB.

The goal is to create a site that enables you to build your own PC to
your spec, you start off with 6 motherboards to choose from, you
select your desired motherboard which takes you to the next page and
allows you to select your CPU, RAM, Video Card etc etc from drop down
menus and tick boxes. The problem is, as everyone knows, only certain
components will fit certain motherboards. So, I need to some how
associate the right components with the correct motherboards.

Hope you're keeping up!

I've started by creating one table for the motherboards, and a
seperate table for the other components. I need to connect the 2
tables, so when you click the motherboard you want it populates the
drop down menus with the correct components from the database!

I hope this makes sense!

My quesiton is: whats the easiest and most efficient way to approach
this?

Any advice would be great, or if someone could point me to some
related tutorials it would be very much appreciated!

Thanks in advance,

Tom

[John Blessing]

"Tommyj" <tommyj@talk21.com> wrote in message
news:14465c12.0402150923.4d17090@posting.google.co m...

> Hiya Everyone,
>
> I hope someone can help me out with this!
>
> I'm devloping a product database, and have hit a brick wall. I was
> hoping some experts in here might be able to give me a little advice
> as I think I'm missing something.
>
> I'm using ASP and an Access 2000 DB.
>
> The goal is to create a site that enables you to build your own PC to
> your spec, you start off with 6 motherboards to choose from, you
> select your desired motherboard which takes you to the next page and
> allows you to select your CPU, RAM, Video Card etc etc from drop down
> menus and tick boxes. The problem is, as everyone knows, only certain
> components will fit certain motherboards. So, I need to some how
> associate the right components with the correct motherboards.
>
> Hope you're keeping up!
>
> I've started by creating one table for the motherboards, and a
> seperate table for the other components. I need to connect the 2
> tables, so when you click the motherboard you want it populates the
> drop down menus with the correct components from the database!
>
> I hope this makes sense!
>
> My quesiton is: whats the easiest and most efficient way to approach
> this?
>
> Any advice would be great, or if someone could point me to some
> related tutorials it would be very much appreciated!
>
> Thanks in advance,
>
> Tom

I would define a "motherboard_type" column in the motherboard table and the
other_components table. . All other_component records should have a value
in this column that matches the relevant record(s) in the motherboard
table.

--
John Blessing

[url]http://www.LbeHelpdesk.com[/url] - Help Desk software priced to suit all
businesses
[url]http://www.free-helpdesk.com[/url] - Completely free help desk software !
[url]http://www.lbetoolbox.com[/url] - Remove Duplicates from MS Outlook

[Don Grover]

Create a column in your motherboard table and call it VIDGroup do same in
video card table then just associate together
Select videocard from tblVidCards where tblVideoCards.Vidgroup =
tblMotherBoard.VidGroup
Do same for other dependant parts.

Regards
Don


"Tommyj" <tommyj@talk21.com> wrote in message
news:14465c12.0402150923.4d17090@posting.google.co m...

> Hiya Everyone,
>
> I hope someone can help me out with this!
>
> I'm devloping a product database, and have hit a brick wall. I was
> hoping some experts in here might be able to give me a little advice
> as I think I'm missing something.
>
> I'm using ASP and an Access 2000 DB.
>
> The goal is to create a site that enables you to build your own PC to
> your spec, you start off with 6 motherboards to choose from, you
> select your desired motherboard which takes you to the next page and
> allows you to select your CPU, RAM, Video Card etc etc from drop down
> menus and tick boxes. The problem is, as everyone knows, only certain
> components will fit certain motherboards. So, I need to some how
> associate the right components with the correct motherboards.
>
> Hope you're keeping up!
>
> I've started by creating one table for the motherboards, and a
> seperate table for the other components. I need to connect the 2
> tables, so when you click the motherboard you want it populates the
> drop down menus with the correct components from the database!
>
> I hope this makes sense!
>
> My quesiton is: whats the easiest and most efficient way to approach
> this?
>
> Any advice would be great, or if someone could point me to some
> related tutorials it would be very much appreciated!
>
> Thanks in advance,
>
> Tom

[Invotion]

Hi,

Best practice in this situation, when you are trying to
implement a many to many relationship between two tables,
is to add a third intermediary table that links the two.

For example:

Motherboards
------------
motherboardID
brand
etc

Components
----------
componentID
brand
etc

MotherboardComponents
---------------------
motherboardID
componentID

This will allow you the greatest flexibility with the
least administration. Any number of components can then
be linked with any number of motherboards.

Sincerely,
Invotion Engineering Team
Advanced Microsoft Hosting Solutions
[url]http://www.Invotion.com[/url]

>-----Original Message-----
>Hiya Everyone,
>
>I hope someone can help me out with this!
>
>I'm devloping a product database, and have hit a brick

wall. I was

>hoping some experts in here might be able to give me a

little advice

>as I think I'm missing something.
>
>I'm using ASP and an Access 2000 DB.
>
>The goal is to create a site that enables you to build

your own PC to

>your spec, you start off with 6 motherboards to choose

from, you

>select your desired motherboard which takes you to the

next page and

>allows you to select your CPU, RAM, Video Card etc etc

from drop down

>menus and tick boxes. The problem is, as everyone knows,

only certain

>components will fit certain motherboards. So, I need to

some how

>associate the right components with the correct

motherboards.

>
>Hope you're keeping up!
>
>I've started by creating one table for the motherboards,

and a

>seperate table for the other components. I need to

connect the 2

>tables, so when you click the motherboard you want it

populates the

>drop down menus with the correct components from the

database!

>
>I hope this makes sense!
>
>My quesiton is: whats the easiest and most efficient way

to approach

>this?
>
>Any advice would be great, or if someone could point me

to some

>related tutorials it would be very much appreciated!
>
>Thanks in advance,
>
>Tom
>.
>

[Bullschmidt]

Or perhaps do things on one page that gets refreshed after each listbox
change.

ASP Design Tips - Dependent Listboxes
[url]http://www.bullschmidt.com/devtip-dependentlistboxes.asp[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Tommyj]

thanks for the advice fellas! You've been a massive help.

I think I'm going to go with the option of having 3 tables, it seems
the most straight forward for my situation.

Regards,

Tom

Bullschmidt <paul@bullschmidt.com-nospam> wrote in message news:<OL15pjO9DHA.2856@TK2MSFTNGP10.phx.gbl>...

> Or perhaps do things on one page that gets refreshed after each listbox
> change.
>
> ASP Design Tips - Dependent Listboxes
> [url]http://www.bullschmidt.com/devtip-dependentlistboxes.asp[/url]
>
> Best regards,
> J. Paul Schmidt, Freelance ASP Web Developer
> [url]http://www.Bullschmidt.com[/url]
> ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!