[TYPO3] backend 1-1 table relation

[Gijs Epping]

Hello,

I only need to get a title from a other table, the uid's are the same.

Company:-------------
uid = 1
title = 'company name'


Employee:------------
uid = 23
title = 'employee name'
company_uid = 1


The idea is that when you open employee for editing (backoffice) you see 
the company name in a not editable field (only for reference)


Is it possible to solve this without a MM table?

example code in employee TCA:
		"company_id" => Array (		
			"exclude" => 1,		
			"label" => "Company name:",		
			"config" => Array (
				"type" => "none",	
				"internal_type" => "db",	
				"allowed" => "company",	
				'foreign_table' => 'company',
				'foreign_field' => 'uid',		
			)
		),	


Thanks in advance
regards Gijs