value list relationships

[seattleflo]

Hi,

Is there a way to create relationships between value lists, so that if I select "1" from the field "expense number" only certain items appear from field "expense type"?

If I select "2" other items from the "expense type" value list are able to be selected, etc...

I have attached a generic file with these two fields and associated value lists.

Basically, I would like for the user to select a number from the "expense number" field and only see the items that are applicable from "expense type."

In this case, we could say, "Choosing '1' from "expense number" = only seeing 'rent and gardening' as options for selecting from "expense type."

Thanks.

SeattleFlo

valuelists.zip

[mr_vodka]

See this thread.

Link

[Fenton]

Value Lists are not data* really (thought one may read from data in a field); there is no such thing as "a relationship between value lists".

You have 2 fields, but the only thing that can be done with these 2 would be to create a filter based on existing entries. Which may be useful for Finds, but is not sufficient to enter new data (the old chicken and egg problem). What it sounds like you want is a "reference" table, where the correlations between the 2 things are pre-defined, for later choices.

* I should say they are not "field data"

value_list_selections.fp7.zip

Edited August 18, 2007 by Guest

[seattleflo]

Thanks for the explanation and help.

Couldn't be more helpful.

(=

Seattleflo