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?

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

Stored...all relationships appear on relationship diagram.

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

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.