The problem is if I link to this table, it uses the primary column which doesn’t help if I want to have a lookup function that will automatically give me the playing squad for a player in any given year
In order to generate the Playing Squad, you need to have a Linked Field and use a Lookup on this linked field.
If you want the latest one, create a view in the Master Table that has only the latest one, and set up your table to lookup to this view. Same goes for the Chart Block, if you dont want all years showing, then make a view with a filter that displays inly the last year.
The colors in the blocks cannot be changed, the sorting can be changed if you change the order of the select field which is used as the legend.