I am trying to set up a tabel and forms that is not sorted / semi sorted in a fixed format
The table has a produduct Class, Brand and some other values.
The keys right now are Class, Brand as there are multiple brands under one product class.
I am fine wiht the sorting other than I want our brand listed first and the brand “other” listed last.
I also want the Class in a particular order that is not generically sortable.
Do I just add a field for Class priority and Brand Priority as a numeric and add them as Keys and sort that way?
This is what I want
Class B Brand Ours
Class B Brand X
Class B Brand Other
Class C Brand Ours
Class C Brand X
Class C Brand Other
Class A Brand Ours
Class A Brand X
Class A Brand Y
Class A Brand Other