Thank you kindly, have accepted as solution. Not back to the office till early Jan but this should do the trick just perfect. Will default the null ones to somewhere on the map that won't. Are sense so can isolate and fix lookup accordingly. As new Tenants come on board they'll naturally appear in the search results but lookup will always be playing catchup and don't want it to start failing each time. Appreciate it!!
... View more