Hello!

Hello!

I am having an attack of stupidity and can't figure out where I am going wrong.
This is my dataset ( TFDMemTable ):

object tblJobs: TFDMemTable
OnCalcFields = tblJobsCalcFields
FieldDefs = <>
IndexDefs = <>
FetchOptions.AssignedValues = [evMode]
FetchOptions.Mode = fmAll
ResourceOptions.AssignedValues = [rvPersistent, rvSilentMode]
ResourceOptions.Persistent = True
ResourceOptions.SilentMode = True
UpdateOptions.AssignedValues = [uvCheckRequired, uvAutoCommitUpdates]
UpdateOptions.CheckRequired = False
UpdateOptions.AutoCommitUpdates = True
StoreDefs = True
Left = 408
Top = 152
object tblJobsID: TAutoIncField
FieldName = 'ID'
Visible = False
end
object tblJobsCOMPANY_ID: TIntegerField
FieldName = 'COMPANY_ID'
Visible = False
end
object tblJobsREFERENCE: TWideStringField
DisplayLabel = 'Ref#'
FieldName = 'REFERENCE'
Size = 255
end
object tblJobsTITLE: TWideStringField
DisplayLabel = 'Job'
FieldName = 'TITLE'
Size = 255
end
object tblJobsCOMPANY_NAME: TWideStringField
DisplayLabel = 'Company'
FieldKind = fkLookup
FieldName = 'COMPANY_NAME'
LookupDataSet = tblCompanies
LookupKeyFields = 'ID'
LookupResultField = 'NAME'
KeyFields = 'COMPANY_ID'
Size = 255
Lookup = True
end
object tblJobsSIGNED_OFF: TBooleanField
DisplayLabel = 'Signed off'
FieldName = 'SIGNED_OFF'
end
object tblJobsJOBTYPE: TWideStringField
FieldKind = fkLookup
FieldName = 'JOBTYPE'
LookupDataSet = tblJobType
LookupKeyFields = 'ID'
LookupResultField = 'TYPE_NAME'
KeyFields = 'JOB_TYPE_ID'
Size = 255
Lookup = True
end
object tblJobsJOB_DESCRIPTION: TWideStringField
FieldKind = fkCalculated
FieldName = 'JOB_DESCRIPTION'
Size = 255
Calculated = True
end
object tblJobsJOB_TYPE_ID: TIntegerField
FieldName = 'JOB_TYPE_ID'
end
end

There are two lookups: JOBTYPE and COMPANY_NAME.

I am using a cxGrid but the lookups don't work properly.
Here is how the company one is defined:

object grdJobsDBTableViewCOMPANY_NAME: TcxGridDBColumn
DataBinding.FieldName = 'COMPANY_NAME'
Width = 150
end

There's not much here, so it should just work because everything else is default.

Has this ever happened to you? Would you know what's going on?

Thanks!