[TYPO3-english] sr_feuser_register: howto create dependencies in the FE? (where clause)

[Thomas Meixner]

Hello list,

I have extended sr_feuser_register or rather the fe_user table with some 
region fields with dependancies region(mrc)->city->district.(cascading 
dropdown lists)

In the backend the dependencies are displayed correctly, if I select a 
region in the dropdown only the relevant cities are shown in the 
dropdown box. I think this is accomplished through the 
foreign_table_where code in the TCA:

'foreign_table' => 'tx_dmmjobcontrol_city',	
'foreign_table_where' => "AND 
tx_dmmjobcontrol_city.mrc=###REC_FIELD_tx_feuserfields_mrc### ORDER BY 
tx_dmmjobcontrol_city.name",


In the FE, sr_feuser_register replaces the
###TCA_INPUT_ part however it just lists the table - the "WHERE" clause 
does not apply here. I have pasted below the snipped of the template.

How can I get the dependencies working in the FE? Where do I add the 
"where" clause, refresh the page and load only the relevant fields.


Thanks for any pointers in the right direction

Thomas Meixner




<!-- ###SUB_INCLUDED_FIELD_tx_feuserfields_mrc### -->

<label 
for="tx-srfeuserregister-pi1-txfeuserfieldsmrc">###LABEL_TX_FEUSERFIELDS_MRC### 
###REQUIRED_TX_FEUSERFIELDS_MRC###</label>

###TCA_INPUT_tx_feuserfields_mrc###

<!-- ###SUB_INCLUDED_FIELD_tx_feuserfields_mrc### -->


<!-- ###SUB_INCLUDED_FIELD_tx_feuserfields_city### -->

<label 
for="tx-srfeuserregister-pi1-txfeuserfieldscity">###LABEL_TX_FEUSERFIELDS_CITY### 
###REQUIRED_TX_FEUSERFIELDS_CITY###</label>

###TCA_INPUT_tx_feuserfields_city###

<!-- ###SUB_INCLUDED_FIELD_tx_feuserfields_city### -->