[TYPO3-english] TCA config

Naberd Zendi naberd at uwkm.nl
Mon Dec 11 13:58:54 CET 2017


need help to set up relation in TCA

have table1 with  description, serial
have table 2 with  name, description, price, serial.
default fields are also present like sys_language_uid, uid, pid...

so i need to point table2.description to table1.description where table1.serial = table2.serial

have now this:
```
			    'foreign_table' => 'tx_uwkmoffer_domain_model_descriptions',
			    'foreign_field' => 'serial',
			    'foreign_label' => 'description',
			    'foreign_table_where' => 'tx_uwkmoffer_domain_model_descriptions.serial = ###REC_FIELD_serial###',
```

partially it does the job when i add description it sets the record in database but the serial field in table1 is filled with uid from table2.

i can't use uid's for refernece since table2 can be trashed, and reimported.

the only field which always remains the same is serial. 


More information about the TYPO3-english mailing list