Forum Discussion
EvanMartinez
7 years agoModerator
Hi Gene,
The next thing I would suggest is to move from the form properties into the field properties. You can find those by right clicking on the report link again and selecting edit the form properties. From there you should see what field in your current table is matching what field in your related table. I would just make sure the field there and the field you are using as the reference field for your relationship are the same.
You can do this by opening up your relationships in your table setting and making sure the Reference field there matches the field being used in your Report link field. Sometimes a report link can be using a different field from the relationship and that can also cause summary fields to not match the report link since they might be looking at a different field for their match.
The next thing I would suggest is to move from the form properties into the field properties. You can find those by right clicking on the report link again and selecting edit the form properties. From there you should see what field in your current table is matching what field in your related table. I would just make sure the field there and the field you are using as the reference field for your relationship are the same.
You can do this by opening up your relationships in your table setting and making sure the Reference field there matches the field being used in your Report link field. Sometimes a report link can be using a different field from the relationship and that can also cause summary fields to not match the report link since they might be looking at a different field for their match.