sorting conditional list based on relationships

[quintana-roo]

I have a bank account program with the category list in a separate table. Each category has one of 8 group names (like a transaction type) and a biz ref (we operate several businesses)

 

In the banking table, for each record, the group name is chosen with a pop-up list that just pulls from that field in the category table. The category pop-up list is conditional based on the relationship of group names. So, the categories are chosen from a list that has that group name - it works great, but I'd like it to sort by a second field, the biz ref. But when I go into the value list window and choose Sort by Second Field, it only shows one category per biz ref, or a choice of 6 categories, not the 38 categories that actually are related by group. How can I get all 38 categories to show up in my list, sorted by the biz ref?

[aaa]

The best way to have universal value list is to wright a script, which opens file with needing fields and records. Any record must have "Use" button, which you press and choose this value. It is not so arduous to construct such script.