Value List from Related Table not Updating
I have a Value List which is showing only related values in another table. When adding records to that table, my Value List is not showing them. If I EDIT an existing record in the related table, the change does appear in my Value List. What can be wrong?
I checked all field types, and the matching fields are all Numerical. I've checked the data and they're numbers (either 1 or 2) with no extra spaces. I removed indexes from these numerical fields, and also from the primary key field of the related table, then turned indexing back on. I did a Save As / compressed file to try to fix any issues with the database. No luck.
If I remove the contraint limiting me to only related records, all values in the related table appear including the new records. I use this structure in other fields and tables, and those Value Lists properly show me new records.
We had a VM server disconnect from storage two days ago, so basically a hard crash on all of those VMs including my FileMaker Server (v12.05). So maybe something was damaged with this table, value list or relationship. Either I'm staring right at something obvious, or something is damaged. How to fix?
All ideas welcome. Thanks in advance!