Assigning two different value lists to a field

[AnotherNewGuy]

I have a field where people need to enter either a project name, or if it's not related to a project, they need to select from a list of non-project related choices. The project list comes from two fields (project number, project name) in a separate database that houses all of the projects and other project-related information. The non-project related list will be a static value list.

There is a checkbox that the user should check if the request is not related to a project. If the box is checked, the value list should be the static value list from within the same database, but if the box is unchecked, the value list should be the list of projects directly from the two fields in the related project database.

Can anyone suggest a way to do this?

Thanks!

[Raybaudi]

You could try this idea ( works even with v 9 )

TwoValueLists.zip

[AnotherNewGuy]

Thanks, I implemented it, and it works great! Your solution impressed me, I wouldn't have thought of doing that!!

[Raybaudi]

Working with 11 or 12 you could use a trigger and the solution will be simpler.

TwoValueLists.zip