It’s basically just a VLOOKUP is how I explain it to my friends who might be familiar with excel but not a real database.

I once dropped a table in a production database.

I never should have had write permissions on that database. You can bet they changed that when clinicians had to redo four days of work because the hosting company or whatever only had weekly backups, not daily.

So, I feel your pain.