I am having a problem with my conditional value lists. When I go to enter an item it works just fine but when I go to find a record it is not working. Can anyone understand? I have other conditional lists on the form, they are all working in find mode.

Sounds like the data for the value list is "unstored", although the relationship maybe valid.

Check the field defs for your related key field and the field for your value list. If either are unstored then FMP can't index and either:

1. The relationship will fail, or

2. The value list will fail becuase it is "unstored"

I have checked both fields to make sure, but they are both stored. have you any other ideas?

What do you mean by not working in Find mode?

You can't enter the field?

The value list is missing?

Have you checked if the field is in header or footer if the layout is list view?

Does the field have the list attached at all? (sometimes you migth make multiple selection of fields and than change some attribute without intending to change it for every field in selection)

And finaly, is this a second (or higher level) value list, ie based on values from previously selected item in lower level value list(for ex. country-->region-->town)

If so than this kind of list can't be use in find mode, unless you activate manualy (via script) the involving relationships.

HTH

Dj