Populate field based on match with another field in another table

The only way to achieve this would be with a Pipe. It’s not super complicated, but requires some Pipe knowledge.

You’d need to create a pipe that queries that second table and filters to only show records where license number matches then update the connection field with that ID.

You can see this thread of something different but similar concept: Count Users with specific status