Naberd Zendi
2017-12-11 12:58:54 UTC
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.
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.