Portal not displaying related records

[kenseye]

I have a Patient file displaying data from a Reports table and Evaluation table through their individual portals. Both Reports and Evaluations are related to Patient via PatID field. Evaluation and Report tables are related through Eval#.

TempID is a global field accessed via a universal link calculated field _constant=1

Script to create Report record:

set field Evaluation:TempID, Eval#

go to layout Reports

new record request

set field Report:Eval#, Evaluation_constant:TempID

set field Report:PatID, Evaluation:PatID

The Report and Evaluation tables are related through Eval# because data from Eval is merged into the Report record.

I know my PatID fields in both Patient and Reports are correctly populated, but the data from Reports does not display in the portal with relationship Patient:PatID=Reports:PatID.

Any explanation why? and how to fix?

[Vaughan]

Is the PatID field in reports stored or unstored? Unstored fields cannot be used for the right-hand side of relationships.

[kenseye]

Stored...all relationships appear on relationship diagram.

[Lee Smith]

Hi Ken,

Please update your profile to reflect your platform, operating system and version of FileMaker. The link is just below your name on the left "profile".

TIA

Lee

[-Queue-]

Since the tables are related through Eval#, you may need to Exit Record/Request or Commit Records/Requests (depending on your version), after setting its value, before setting the PatID. Otherwise the relationship may not exist yet.