Hi, i have an issue with set relation method
I have tables: departments, directions, positions, employees. Additionally i have aggregation table employee_department where i'm adding new employee based on prev dictionaries.
Now, i have a table were admins assigning to employee_department record id. I want to relate and concatenate department, direction, position and name of the record in employee_department table. But those values are in dictionaries, in employee_department i have only it's ids. Can i do something like this?
This gives my only the ids of employee_department record. And want to get its name or title values from related dictionaries