Dear Community
I have two tables. A “person” table with personal information like name, surname, birthday, gender, …
and a second table “person_planing” with fields like date, costs, travel_costs and where I have a “belongsTo” relationship between both tables.
All works fine.
When I now have the table UI of person_planing I can access all fields of “person” quite easy.
My issue is, that I want to sort also over the “person” fields like name and gender which is not possible. The same with the excel export. When I export rows of “person_planing” I jus get the “person_id” column instead of all person fields like name, birthday and so on…
Does anyone has a workaround?
I tried a SQL view which works for exporting and sorting but then I have no action capabilities like add & delete a row… 
Many thanks
Christian
