Product and version
Filemaker Pro 126.96.36.1993
OS and version
Windows Server 2008
We have a relationship based on a calculated field that doesn't work as expected. We checked the values of the calculated field and there definitely should be records in the portal, but there aren't.
How to replicate
Create two tables, TableA and TableB.
TableA Fields: ZC_TRUE (calculation, global storage, '1'), id (text, any unique id)
TableB Fields: id_TableA (text), FieldA ( text ), ZC_VALID (calculation, 'IsValid ( GetFieldName ( Evaluate ( FieldA ) ) )' )
Relationship: TableA::id = TableB::id_TableA, TableA::ZC_TRUE ≠ TableB::ZC_VALID
Create a record for Table A and two for Table B that each contain the id of Table A in TableB::id_TableA. Put "TableA::id" as text in the TableB::FieldA in one record and "TableAAAA" in the other record. The field ZC_VALID should be 1 the first and 0 for the second record. Therefore the second record should be found through the relationship, but it isn't.