Hi All,
I have a few reference tables, let’s give example:
One table is the Personnel table, which is linked to “cars” and “houses” and “bicycles” tables.
So when i view Personnel, i have the three reference tables underneath.
Questions:
Thanks!
Solved! Go to Solution.
#1 - You can reorder them with the option called “Column order”. You can find it under your detail view’s definition.
#2 - You can use an expression ORDERBY… like ORDERBY(Personnel[KeyColumnName],[NameColumn],FALSE)
Thanks guys!
I’m struggling with this scenario : I have a car REF column in the Personnel table which references the Car table.
How do i order this list of cars in the dropdown that pops up?
I’m not sure where to put the ORDERBY(…) ? In the column formula? initial value? suggested value? somewhere else?
Use it with the Valid If option.
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |