You may need to set this up to work in browse mode instead of find mode. It's possible to set up some global fields on a layout where you select your values in these global fields, then you click a button and a script uses the data in the global fields to perform the find for you.
The main drawback to this is that you would need two sets of conditional value lists and relationships: 1 for data entry and a different set that works off of the global fields for performing finds.
I was using the drop box to help narrow down the find for someone who doesn't know, or remember, what values are available in the find. If I use global fields to store the data I want to use in the find, then I"d have to know those values before I start correct?
No, this is not correct.
Hmmm, could explain further? I'm not following your solution.
Sorry, but at the time I saw your previous post, I had to fire off a quick response and run.
I decided to set up a test file and check something before going off into the world of scripted finds.
I found that when I set up hierarchical conditional value lists, they worked just fine in find mode. So I suspect you've used a different approach than I have in setting them up.
Here's a link to the file I used for testing: https://dl.dropboxusercontent.com/u/78737945/ConditionalValueLIstInFindMode.fmp12
That gets me a working set of drop boxes to do a find. If I'm understanding correctly, I'd create the source list in the ValueList table in which I'd enter.....
Type = Vegetable
Style = Sliced or Coins or Whole or Chopped or Canned
Size = No Value or 8Oz or 16Oz
Then user would also have to go to ConditionalValueListInFindMode where the drop boxes would draw on these values to allow him to populate that list with duplcate values.
I suppose I could write a script that would automate the duplcation process, that would check for duplcate values then use those to populate the Conditonal List. I could add the photos to that table so that the end user (the one looking for my shots not entering my shots) could easily look to see how many versions of carrot sticks we'd shot.
What I had tried was to keep using copies of the ValuesList Table. The first provides values for the Type Field. The second copy povides drop options for the Name field, starting with matching values from the first copy. The Third provides values for the Style startign wtih matching Type and Name values from the second etc etc. It works great to create new records but when I try the same layout in find mode the drop boxes stop working after the 2nd level.
I'll give your method a shot as mine is going nowhere fast.