Value list from calculation field

[pspafford]

Hey kids.

Here's my situation:

I have a file called Bookmark Manager.fp5, with two value lists.

1. First value list: Category from field USR_tCategory.

USR_tCategory is a text field that the user either picks a category from the value list, or types in a new one.

2. Second value list: ViewAs from field KEY_cViewAs.

KEY_cViewAs is a calculation field for the sole purpose of providing a value list to search USR_tCategory (through a relationship). The calculation for KEY_cViewAs is: "all by category" & "

[BobWeaver]

You have to have the KEY_cViewAs field indexed because Filemaker uses the index as the value list. So, you have to force the field to recalculate whenever you change categories. By including a reference to the appropriate field you can force the field to recalculate. I use something like Left(TriggerField,0) which doesn't contribute anything to the actual calculation but causes it to recalculate whenever TriggerField is changed. So your formula would become:

"all by category" & "

[pspafford]

I am in the presence of sheer brilliance, Bob. It worked; there is no way I ever would have thought of that.

Thanks, eh.

Paul