Making other Value list change from another

[Heathbo]

I have a layout with 5 popup list that ether says active or complete. Its basically a list of things to do.

The popup lists are labeled 1, 2, 3, 4, 5. What I need to happen is, when complete is selected in 3, list 4 and 5 will automatically change to complete as well. Any help you can give is much appreciated.

[Brian C]

Theoretically I think this could be accomplished using a related table to store your value list.

If you have your stored value list in the table have 1 record per value and have 2 fields for each record. One could store the value and the other could store the "complete" entry. Example

Field 1 Field 2

------ ------

1

2

3

4

5

Complete Complete

You could have each of the fields set to be auto-entered lookups from field 2 that will not lookup if the related data is empty in field 2.

By making each of the fields in succession dependant on each other via several relationships, I think you could have the remainder of the fields populated with the "complete" in this manner.

I have not tried to do this yet myself to see if filemaker will do that many lookups in succession, but I believe it should work.

[comment]

Perhaps there is a simpler method.

Define field list4 as auto-enter calculation (replaces existing value) =

Case ( list3 = "complete" ; "complete" ; list4 )

[Heathbo]

If I turn them into calculation fields, how do I still use them as value list? A calculation field isn't modifiable.

[Heathbo]

If I turn them into calculation fields, how do I still use them as value list? A calculation field isn't modifiable.

[Heathbo]

If I turn them into calculation fields, how do I still use them as value list? A calculation field isn't modifiable.

[MoonShadow]

Heathbo, Comment isn't suggesting you make list 4 and 5 calculation fields but rather add an Auto-Enter using a calculation.

auto-enter calculation (replaces existing value)

They remain standard fields but will change their data in response to what is entered (or changed) in 3. Be sure to unclick 'Do Not Replace Existing Value.'

[MoonShadow]

Heathbo, Comment isn't suggesting you make list 4 and 5 calculation fields but rather add an Auto-Enter using a calculation.

auto-enter calculation (replaces existing value)

They remain standard fields but will change their data in response to what is entered (or changed) in 3. Be sure to unclick 'Do Not Replace Existing Value.'

[MoonShadow]

Heathbo, Comment isn't suggesting you make list 4 and 5 calculation fields but rather add an Auto-Enter using a calculation.

auto-enter calculation (replaces existing value)

They remain standard fields but will change their data in response to what is entered (or changed) in 3. Be sure to unclick 'Do Not Replace Existing Value.'

[comment]

[comment]

[comment]

[Brian C]

Ahhh the power of FMP 7! The more I learn about it, the more I appreciate the genious that went into making it. And having a great place like this to learn and share ideas doesnt hurt! Kudo's to all of you who make this board such a great place.

[Brian C]

Ahhh the power of FMP 7! The more I learn about it, the more I appreciate the genious that went into making it. And having a great place like this to learn and share ideas doesnt hurt! Kudo's to all of you who make this board such a great place.

[Brian C]

Ahhh the power of FMP 7! The more I learn about it, the more I appreciate the genious that went into making it. And having a great place like this to learn and share ideas doesnt hurt! Kudo's to all of you who make this board such a great place.