Hi Charles,
Is that Attorney Name field in Local Council's part of a relationship between those two tables or is that Attorney Name field just a multiple choice type field with the Input Type set to 'From another field'? The second option "From another field' unfortunately doesn't create a relationship between the two tables, which can make bringing over other data far more complicated as there is no relationship between the field and its source to bring down information via Look up fields, etc. So I just wanted to clarify if that Attorney Name field that you are using in your record is part of a relationship or just using this option as Formulas aren't able to draw values from other tables, they function in a record on a single table.