Hi Jainish, this is not working without FlexForms but with common definition in TCA too. I just have the same problem where I want to limit of found data. So your problem is related to the core but not to FlexForms.
David Date: Fri, 03 Jun 2016 16:00:06 +0530 > From: Jainish Senjaliya <jainishsenjal...@gmail.com> > > 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> > > _______________________________________________ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english