In my setup, I have two tables, one with users and one with user groups.
The link between these tables is that multiple users can be linked to the same group.
As I will be using a tree control, I already created a foreign key and a relation to map the user with the group id.
Can I make the group name (or any other group KPI) visible as a column in the users table without copying (duplicating) the data?
I tried using the option view directly on the users table but this didn't worked.
Hi,
It's currently not possible to add view columns to a real table.
You're going to have to create a new view table, let's say 900, which is a view on 800 and the first columns of 900 will be the view on the columns of 800. The last column of 900 is then a view of 702.
In other words, the first columns of 900 will have view=801, view=802,... the last column will be view=805:702 (start in foreignKey 805 and get linked column 702 to be viewed)