Best guess is that you are using a relationship for your conditional value list something like this:
LayoutTable::categoryfield = ValuesTable::CategoryField
Where you select a value in categoryfield on the layout to control what values from the ValuesTable appear in your value list.
To add an "all" feature, do this:
Define a calculation field in ValuesTable, cCategoryAll as:
List ( CategoryField ; "-All-" )
and modify your relationship to be:
LayoutTable::categoryfield = ValuesTable::cCategoryAll
Then add -All- as a value to your value list of categories.
If you draw your list of Cateogries from a field in a table, a similar calculation method can be used to add -All- to the value list and it will sort to be the first value in your value list.
Hey Phil nice to see you again,
Heres my relationship I have set up currently and what my problem is now when I go to the main menu layout to choose from the portal; no options will show up.
This data base is based off your example program you gave me on the conditional value listings.
Did you select text as the result type for the calculation field?
Yes, and it still wont show anything.
I can see from the "T" connector that:
is not defined correctly. It should be a stored indexed calculation field that only refers to fields in the Person4ConditionalValueLIst table. Make sure that no fields referenced in this calculation include TableName:: as the first part of the field's reference. Maker sure that both "global" and "do not store" are not specified in storage options for this calculation field.
Thank you, it wasn't indexed and now its working correctly!
Do you think its possible to have a group named Temporary that people can get put in but, once the app is closed they are all removed from the group? I know I could do it without the portal setup but I would enjoy having that incorporated. Any help would be appreciated.
A script can be set up in File Options with OnLastWindowClose to perform a script when the file is closed. This script can perform a find for all records with "temporary" and then do whatever is needed to "remove them".