Value Lists based on Related Values fail in FMP12
Operating system version
Description of the issue
When a value list is set up to show only related values - see screenshot - it works correctly for the first record. When you go to a different record and click the value list, it shows values that were correct for the first record, but not the current one. All subsequent records have this behaviour, until you go back to Define Value Lists and edit the value list and then click OK.
It works correctly for the first record, then fails once another record is selected.
This value list was working correctly in FMP11 and previous incarnations.
As a matter of interest, FileMaker has always displayed
Have tried adding script triggers to refresh the record before going into the list, but the only thing that refreshes the value list is going into it in Define Value Lists.
May be that it is failing because we have a large number of records in the system, but it has always worked correctly before.
Can FMI please have a look at this?