Data from other tables (cascading)

First, thanks for delivering Radzen Community. It is a great way for learning. I am trying to build a simple app for keeping record of harvest in my green houses. The app that I built once in MS lightswitch worked with some tricks cascading the dropdowns forms and when using in Power BI the reports too. The model was made of 1 to many relationships starting at Seasons Table => Greenhouse Table => Variety Table => Acreage or Area Table => Harvest Table. To set up the current season I need to get into the Areas Table the cascading of the season, a list of active greenhouses and varieties. When building the form in Radzen, how I can get data from other tables further than the ones I get from the lookup based on the immediate relation?

Hope I explain myself…


Please check these threads for more info:

Best Regards,