AnsweredAssumed Answered

Dependent list in a Find does not work

Question asked by SeligL14FM on Sep 27, 2014
Latest reply on Sep 29, 2014 by TSGal

Summary

Dependent list in a Find does not work

Product

FileMaker Pro

Version

13

Operating system version

Windows 7

Description of the issue

I have an Items list that is created based on the entry in the related Substance field.

I have a SUBSTANCE file with a CATEGORY field  that is related to an ITEMS file by the Items Category field.

I use this relationship to create a Use Items List that has items based on the Substance Category  chosen.

This works fine during data entry but fails in a Find (the Items drop down is blank i.e. did not get the Category entered in the FInd).

I presume the problem is either a bug or a value in a Find is not the same as an entered value.

Any help would be appreciated.

Steps to reproduce the problem

Create two files and relate by a Category Field (Substance and Items). The Items file has Category and Item fields.

The Items Value List is created based on related values in the Substance file Category field, providing a subset of the Items that have the same Category value

Expected result

I would have expected the Item drop down would work in a Find just as it does during data entry

Actual result

Item dropdown in FInd is blank after entering Cateory value in find for the Substance Category

Exact text of any error message(s) that appear

No error - just a blank drop down

Workaround

none

FM_Entry_%26_Find.jpg

Outcomes