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

[geoff_gardener]

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