Data Grid Sources

How can I pull in several columns from one table and then line them up with additional columns from related tables.For example, if I had Employees with their ID number and Name from one table, how could I pull up the data from another table with their position info and salary. I'm also interested in how to sort them with buttons. How could I always pull up Employees by ID and then press a button to get only the ones with Position "Front Desk"?

[Table One        ][Table Two                 ]
Employee Id | Name | Employee Position | Salary
123456      | Bob  | Front Desk        | $15

I'm very new to this so any help would be greatly appreciated. Thank you!

Hi @HRichard,

There isn't a direct way to do that from Radzen. You can however create a SQL view from those tables that joins them into one.