Hi!



There are a few questions that need to be sorted out:



First of all, to whom do I send the bill for doing the design?

Two: Does a SubCategory have to belong to a Category?



As far as I can see, you need the 3 tables, but with some changes:



Category:

CatID, Catname





Subcategory:

SubcatID, Subcatname





Accessory:

AccID, AccName, CatID, SubcatID, Color, Weight, etc





Then in the form you only insert data to one table. Only in rare cases you

want to insert data in more then one table. In that form you have two

dropdown boxes showing the Catnames and Subcatnames respectively. When form

data is submitted ie an accessory is added to the the table Accessory, you

send the CatID and SubCatID along with the rest of information to the

Accessory table.



This is a straight forward and simple solution. However, if one subcategory

has to belong to a Category then the solution is a little more advanced and

I need an answer to my first question ;-)



Hakan









-----Ursprungligt meddelande-----

Fran: arshad siddiqui [mailto:ash_arshad@y...]

Skickat: den 14 februari 2002 09:55

Till: ASP Databases

Amne: [asp_databases] very important





Hi,

I wanna know how to design my database.

I want to make a database called Ramy.mdb now in that

there will be three tables:

1.Category

2.SubCategory

3.Accessory

Now in Category there will be two columns named

CategoryID(P.K) and Categoryname,In SubCategory there

is confusion shall I put two columns SubCatId and

SubCatName.Then join the two tables.

Third table is Accessory here all the details will be

there along with CategoryID and SubCatName.



I want to make a system where I can upload into the

database by putting all the values of

category,subcategory and all the details of accessory

from a single form.

Please do suggest me about the database design.

I will be really obliged by your help

Thank you

Regards

--Arshad--





__________________________________________________

Do You Yahoo!?

Send FREE Valentine eCards with Yahoo! Greetings!

http://greetings.yahoo.com






$subst('Email.Unsub').

Hi Hakan,

Thanks for your help.

Sorry for the delay as I was indisposed.

I didnt got your first question please explain.

Subcategory should belong to some category.I think all

the three tables should be interlinked but the problem

is how?

second thing is if I interlink the tables and make

relation then how to Upload the things.

Thanks

Regards

--Arshad--





--- Hakan_Frennesson <hakan@c...> wrote:

> Hi!

> 

> There are a few questions that need to be sorted

> out:

> 

> First of all, to whom do I send the bill for doing

> the design?

> Two: Does a SubCategory have to belong to a

> Category?

> 

> As far as I can see, you need the 3 tables, but with

> some changes:

> 

> Category:

> CatID, Catname

> 

> 

> Subcategory:

> SubcatID, Subcatname

> 

> 

> Accessory:

> AccID, AccName, CatID, SubcatID, Color, Weight, etc

> 

> 

> Then in the form you only insert data to one table.

> Only in rare cases you

> want to insert data in more then one table. In that

> form you have two

> dropdown boxes showing the Catnames and Subcatnames

> respectively. When form

> data is submitted ie an accessory is added to the

> the table Accessory, you

> send the CatID and SubCatID along with the rest of

> information to the

> Accessory table.

> 

> This is a straight forward and simple solution.

> However, if one subcategory

> has to belong to a Category then the solution is a

> little more advanced and

> I need an answer to my first question ;-)

> 

> Hakan

> 

> 

> 

> 

> -----Ursprungligt meddelande-----

> Fran: arshad siddiqui [mailto:ash_arshad@y...]

> Skickat: den 14 februari 2002 09:55

> Till: ASP Databases

> Amne: [asp_databases] very important

> 

> 

> Hi,

> I wanna know how to design my database.

> I want to make a database called Ramy.mdb now in

> that

> there will be three tables:

> 1.Category

> 2.SubCategory

> 3.Accessory

> Now in Category there will be two columns named

> CategoryID(P.K) and Categoryname,In SubCategory

> there

> is confusion shall I put two columns SubCatId and

> SubCatName.Then join the two tables.

> Third table is Accessory here all the details will

> be

> there along with CategoryID and SubCatName.

> 

> I want to make a system where I can upload into the

> database by putting all the values of

> category,subcategory and all the details of

> accessory

> from a single form.

> Please do suggest me about the database design.

> I will be really obliged by your help

> Thank you

> Regards

> --Arshad--

> 

> 

> __________________________________________________

> Do You Yahoo!?

> Send FREE Valentine eCards with Yahoo! Greetings!

> http://greetings.yahoo.com

> 





> $subst('Email.Unsub').

> 

> 





$subst('Email.Unsub').





__________________________________________________

Do You Yahoo!?

Yahoo! Sports - Coverage of the 2002 Olympic Games

http://sports.yahoo.com