1 Reply Latest reply on Dec 27, 2010 9:09 AM by philmodjunk

    Creating cascading selections of values



      Creating cascading selections of values



      I have a database where I have company divisions in one table, then a table with projects (per divisions), then a table for tasks (per project), and then activities for the tasks in another table.

      I would like to be able to have a layout where I select a division, and only the projects for that division come up,, and then select a project and only the tasks for that project come up and so on for the activities.  I know how to do the layout, but I must be doing something wrong in the relationship graphs.  There is a field linking each table in sequence, for example, the Divisions table has a serial number as each division is added, named DivisionID.  That links to the Project table with DivisionID being in the Projects table as well.  When a new project is entered a new serial number is entered for the ProjectID.

      Its a one to many relationship as follows:

      Divisions -----<Projects linked by DivisionID

      Projects ------<Tasks linked by ProjectID

      Tasks ---------<Activities linked by TaskID

      I would like a layout for entering new data, and also for viewing data.

      Any help would be greatly appreciated.  If I need to take an image of my relationship graph to help you understand I can do so.

      thank you,