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 |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |