Time to create more work for myself...

A small redesign like this would not have been possible withoutJacques  Ninext project. I can see if a field is being used in other formulas (red) or views (green) before I delete them. Here is what I see when I open Edit Fields:

You can see the number by each field that I will be deleting. If I click on the red 4 by rqNum I see:

This field is only used by other fields in the same table. I can either fix the code in the other formula fields or since I'm going to be deleting those fields as well I can just delete this field.

Compared to if I look at where r1Num is used:

There are three other tables that have formulas that depend on this field, so I need to go fix them first before I can delete this field.

Here is an example of how the new subtable makes coding easier. I have a field that looked like this before the new subtable:

let t := this;
switch League do
case 1:
    switch 'Round Type' do
    case 1:
        first(TeamRiders.SeasonsActive.TeamEventSummary[Location = t.Location].r1StartOrder)
    case 2:
        first(TeamRiders.SeasonsActive.TeamEventSummary[Location = t.Location].r1Placing)
    case "Q":
        first(TeamRiders.SeasonsActive.TeamEventSummary[Location = t.Location].QtrStartOrder)
    case "S":
        first(TeamRiders.SeasonsActive.TeamEventSummary[Location = t.Location].SemiStartOrder)
    case "F1":
        first(TeamRiders.SeasonsActive.TeamEventSummary[Location = t.Location].F1StartOrder)
    case "F2":
        first(TeamRiders.SeasonsActive.TeamEventSummary[Location = t.Location].F1Placing)
    end
case 2:
    switch 'Round Type' do
    case 1:
        first(TeamRiders.SeasonsActive.TeamEventSummary[Location = t.Location].r1StartOrder)
    case "JO":
        first(TeamRiders.SeasonsActive.TeamEventSummary[Location = t.Location].r1Placing)
    case "1PO":
        first(TeamRiders.SeasonsActive.TeamEventSummary[Location = t.Location].JOPlacing)
    case "3PO":
        first(TeamRiders.SeasonsActive.TeamEventSummary[Location = t.Location].JOPlacing)
    end
case 3:
    switch 'Round Type' do
    case 1:
        first(TeamRiders.SeasonsActive.TeamEventSummary[Location = t.Location].r1StartOrder)
    case 2:
        first(TeamRiders.SeasonsActive.TeamEventSummary[Location = t.Location].r1Placing)
    end
end

Since you can't put field names into variables, I have to create code that takes into account all possibilities.

and now it looks like:

let t := this;
first(Location.Points[TeamID = t.TeamID].RoundAnalysis[round = t.'Round Type'].startOrder)