Relationships and building drop down boxes from various tables

[Noodle7]

Hi

I am trying to build a database in which there is a main table and in this main table there are products and there are types of products eg.

Ringtones - is the Product and Type - True Tone(mp3), category - R&B
another eg is Graphic is the product and Wallpaper is the type of graphic Category - friends .

I would like to combine this so when you are in the MAIN products table with
"Code" ,"Product" ,"Type" , "Category", "Title", "Artist" and "Price" that the drop down boxes say for instance when you click on "product" and you chose ringtone then in the "type" column there are only the options from the Ringtone type and not also for graphic etc.. is this hectic to do?
Hope I have explained it ok...?
Thanks !
Really hope some one can help me with this ?
Melissa
Cape Town
SA

 

[neileg]

This is known as cascading combo boxes. Well covered in these forums so do a search.