Data from other tables (cascading)

[leam.mx]

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…

[enchev]

Hi,

Please check these threads for more info:

Filter lookup values by other field

@joshbooker I am afraid this won’t be possible as we don’t know what controls a form contains beforehand. We can expose a Change event which will tell what field changed. One can act as needed from there using the Condition property. At some point the UI should be a lot better for cases like this. You are absolutely right that cascading combos are a common scenario. We will think of a way to make it easier to define the relationships between them.

Are these achievable?

If you want the fields to be editable and update as the user types you should handle the Change event of the form and Execute the following Code: this.form0.form.patchValue({BillingName: ${event.value}}) and with the following Condition: ${event.property} == 'Name' [52] form0 - the Name property of your form component. BillingName - the Property which should be updated (the calculated one) Name - the Property whose value is used to update the calculated one. For the ratio it should be s…

Best Regards,
Vladimir