The Visual Studio reports a problem in the LINQ code generated by Radzen for filtering:
generated:
var mySqLserverGetTblIdNumbersResult = await MySqLserver.GetTblIdNumbers(new Query() { Filter = $"i => i.CustomerNumber == '{args.CustomerNumber}'" });
should be with double quotes instead of apostrophes:
var mySqLserverGetTblIdNumbersResult = await MySqLserver.GetTblIdNumbers(new Query() { Filter = $"i => i.CustomerNumber == \"{args.CustomerNumber}\"" });
Sorry, I put this request in wrong place. It is Blazer.
I added an SQL data source with DB containing tables tblCustomers and tblIDNumbers. Then added a page Master/Detail DataGrid, defining Page Schema = TblCustomer and marked Child Data = TblIdNumbers. The field TblCustomer.CustomerNumber became automatically a filter for selecting rows in TblIdNumbers.