LookUp formula not working

[aah]

I have a form in which one of the text labels uses this formula to get the department name.

I cant figure out why but doesn't seem to work and the only error it shows is a delegation error.

Any ideas on what could be the issue?

[EdViegas]

Where are you using this code? Control/Property

[aah]

I'm not sure in regards to control/property.

This is part of the page the form is on I just can't get it to display the department name.

[Drrickryp]

@aah

Assuming that there is a gallery, (say, Gallery1) for selecting the person and the controls are in a form datasource: People and Item: Gallery1.Selected, the default of the textbox should be: 

LookUp(Department, ID=ThisItem. 'Department ID').'Department Name'

[aah]

Thanks for the reply.

My form uses a data source that doesn't have a department ID field so I can't directly LookUp for that. Is there any workaround?

[Drrickryp]

What field in the people table stores the department? If you don't have one, you need to add one. 

[aah]

The 'Department ID' field which is also in the Departments list.