I work for a graphic design firm and will be using the database to help keep track of design projects and tasks.

Question:

Is is possible to create a value list for a specific record?

Explanation:

I have created a relational database that contains a project table and a tasks table. Each project consists of parts or phases specific to that project. For example, one website project may consist of a home page and a clients page, while another website project may consist of totally different pages and page names.

when I create a new task record and assign it to a specific project, I want the "Project Parts" field containing the drop down values to show me only the values/value list appropriate for that project.

Is this possible? If so, how might I achieve it?

Thanks

Edited August 4, 200817 yr by Guest

Yes, this is possible, and relatively easy as well.

First of all, you'll need to define what the list for each project will include. To do this, go to the database that holds the projects and create a field to hold the list. A simple text field will do. Next, populate the field with data. Since it's a dropdown list, you'll be adding several values to the field. There's two ways you can do this. One way is to make the field a repeating field, however, this will make every list as long as your longest list.

The second way is to simply use carriage returns in your list. Enter a value, then hit Shift+Enter to force a return in the list, then enter the next value, and continue from there.

Now, In your tasks database, create another simple text field. This will be used to display the value lists. Once the field is created, double click it in layout mode to bring up the field control setup box, and choose to Display as: Drop-down list.

Now choose "Display values from:" and select the manage value lists. Create a New... list, and select "Use values from field:". Choose the table from the related projects database, and select the field that contains the list you entered. Finally, at the bottom, select "Include only related values starting from:" and choose the Tasks table.

And that should be it. Now, when you click the field in your Tasks database, it should list the entries from your related field in the projects database.

Hope this helps :