We have a database with records that list various organizations' information. Each organization belongs to one of three "Main" groups (ex. Group A, Group B or Group C). We have a pull down button which allows the user to select the correct main group (A, B or C). Each Main group has from 5 - 10 "Sub-groups" under it. Once the main group is selected, we would like the list of the sub-groups for the one selected to appear on the screen. At that time, the user will selected the proper sub-group. Both the main group and sub-group selection will be stored in the main table. There already exists a table of Main-groups. I am sure that I must create a table of sub-groups. I do not know how to have them both work together and how to make the correct list of sub-groups appear on the screen for the user to select from after chosing the main group. Having all of the sub-groups appear on the screen at all times will be a waist of space. I am not sure but this may be a place where sub-table lists must be used. I am also guessing that once the user selects a main group, a pop-up-box listing the available sub-groups will temporarily appear for the user to select from and will dissapear after the selection is made. Any assistance that you can give will be appreciated.