So heres what I'm trying to do.
I have two fields, Group Description and Lean_Projects. They were were in two separate tables but I left joined them together.
So when I make a table I want Lean_Projects to display either 'Lean' or 'Non Lean' depending on the value of Group Description.
Sometimes Lean_projects is null as well, so that would have to change as well.