[TYPO3-english] Flexform : foreign_table_where is not working properly when we use REC_FIELD

[Jainish Senjaliya]

Hello All,

Here i am going to show records from table depends upon category selection.

Here i have used following code.

<foreign_table_where> TABLE_NAME.category = ###REC_FIELD_settings.category### </foreign_table_where>

But this is not working at all

My flexform configuration are below

<settings.category>
	<TCEforms>
		<label>Category</label>
		<onChange>reload</onChange>
		<config>
			<type>select</type>
			<foreign_table>CATEGORY_TABLE_NAME</foreign_table>
			<size>1</size>
			<maxitems>1</maxitems>
			<minitems>1</minitems>
			<show_thumbs>1</show_thumbs>
		</config>
	</TCEforms>
</settings.category>

<settings.grid>
	<TCEforms>
		<label>Product</label>
		<config>
			<type>select</type>
			<foreign_table>PRODUCT_TABLE_NAME</foreign_table>
			<foreign_table_where> PRODUCT_TABLE_NAME.category = ###REC_FIELD_settings.category### </foreign_table_where>
			<size>5</size>
			<maxitems>100</maxitems>
			<minitems>4</minitems>
			<autoSizeMax>20</autoSizeMax>
			<show_thumbs>1</show_thumbs>
		</config>
	</TCEforms>
</settings.grid>

I WANT TO SHOW ONLY THOSE RECORD WHICH IS SELECTED IN "category"

Can anyone guide me 

Thanks in advance

Regards,
Jainish Senjlaiya