Hi I am trying to build a dereference expre...

expressions
(geoff gardener) #1

Hi

I am trying to build a dereference expression between 2 sheets.

  1. Patient profile (which has “Employer” which is a enumlist due to spellings/reporting) 2) Appointment (which requires “Employer” for reporting purposes)

I have used the expression [PatientID].[Employer] in app formula on Employer in Appointment, but I am getting this error:

The expression is valid but its result type ‘List’ is not one of the expected types: Text

Whats the best way around this?

As I need Employer to be a enumlist.

TIA

(Suvrutt Gurjar) #2

Hi @geoff_gardener,Since your Employer field in the parent table is enumlist type(that, by definition of enumlist can have more than one value of employer) , please define the corresponding dereference field Employer in Appointment table also as enumlist type with same dereference expression of [PatientID].[Employer]

(Suvrutt Gurjar) #3

Alternatively, if there can be only one employer for a patient, then you can define the field employer as an enum field in the parent table. In this case, the corresponding dereference field employer in the child

table Appointment can be text type with same dereference expression of [PatientID].[Employer]