Get customername using customernumber

Infer your data source first so Radzen knows about the new foreign key relationship:

  1. Go to the data screen
  2. Click on your data source
  3. Click Infer and Next.

Then you can delete the existing DataGrid and add a new one. Use the "New ..." option from the Data property dropdown to configure the grid. It will allow you to pick columns and should automatically display the CustomerName column.