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