That’s kind of weird, it is multiple, which makes no sense as one record should match only one project number, but when I set it up for single does not pull anything into the column, it does not make logical sense as if multiple pulls one, single should pull the same. Right? Thanks !!
Good to hear. I don’t know why, but it seems like, on rare occasions, switching a relation between multiple and single will cause issues with a Lookup column. I don’t know why, but recreating everything usually works.