Thank you! I poked around and noticed that some records are responding as expected while others are not. Which makes it more confusing. The screen shot below shows both cases.

@Justin_Barrett I found this show and tell-and it is AMAZING! I made a copy of your base and played with it to make sure it would work if I used dates as the base-and it did. But when I incorporated it into my company’s CRM-it didn’t work :frownin...

“I agree. Frankly — and remember, I’m Mr. Unbest Practices — if it was a base in which i personally had to enter data, I’d do neither. If i was concerned about erroneously entering the state, I’d write a formula that broke out the state abbreviation,...

Hi @Pamela_John Thank you for sharing your work. I am trying to do something similar but am having trouble picturing the tables that weren’t added as a screenshot. Would you mind sharing the other ones too? Thank you for your time!