Discussion:
[TYPO3-english] TCA config
Naberd Zendi
2017-12-11 12:58:54 UTC
Permalink
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.

Loading...