Help with a database

hemophobic

I have to do a database project for college and I have a question about Drop down boxes e.g for title I've set it so I can pick from mr mrs ms miss etc. My database is for a jewellery shop and I was wondering if it is possible if I can have different drop down boxes for a certain field depending on another field I.e if ring is selected as the jewellery type I would like the size drop down box to display a,b,c etc but if bracelet was selected as the jewellery type I would like the size drop down box to show small, medium, large etc. Is this possible and how would I do it?

rsykes2000

If you use an Excel spreadsheet, you can set up a pivot table - an example is found at http://www.homeandlearn.co.uk/ME/mes9p4.html

BritRael

Firstly, what software are you intending to use? If MS, Access is a great database program. If you want a simple layout, then Excel (which is a spreadsheet program) could be used. I forget how to do it in Access (try hitting F1 and it'll tell you) but I remember in Excel click Data/Validation/Settings and from the drop down box, select list (a 'source' box will pop up).
Before you do that though, go a few cells to the right of where you want the 'database' data to be and enter your list in separate cells (one on top of the other). You can then click the red arrow in the source box and simply select your list, and click ok. Once you've done this select the cell, and drag it down (by selecting the cross in the bottom right of the cell) as far as you like which will copy this list format to all the cells in the column.
This will only give you a simple list though, you cannot make a 'list within a list' using this method. But of course you could make a column called 'type' containing ring, bracelet, necklace etc. and another called 'size' etc with a list in each.

hemophobic

I am using MS Access 2007 I'll look at the help menu.

onehitwonder

Look at the 'afterupdate' event of the first box.
In this event you can set the rowsource() of the 2nd box to whatever you want. You may want to set the value of the 2nd box to null if you change the first box.

HO87

You can use a number of methods of supplying data into a drop-down box (known in Access as a Combo Box). If all you are going to do is use a number of simple fixed data types - like Mr, Mrs, Countries for example then you could write these into a separate table and have the data brought through into your main table by going to the Lookup tab (in Table design view) selecting "Combo Box" and then selecting your Rowsource (the name of your subsidiary table).

onehitwonder

I wonder what the op did?