Value List filter not updating
I am running FileMaker Pro 10 on Mac OS 10.5.8. I am having a problem with a value list (using only related values) not reflecting newly added records.
I have an Accounts table and a related Users table. The Users table is related to itself using a matchfield for Account Name. On a related (Appointments) layout, I have a popup using the value list "Account Name" which shows all values (~75 of them) and another popup using the value list "Users" which shows only values related to the Account Name match field. This all works very well --until you add a new user to an existing account. The new user does not show up in the Users popup.
Does anyone know what is happening here?