I have an ID column that I have added to my Users table. During the building of the reviews, I would like to access the User ID to construct a link to another part of the site for more detail on that user.

I'm wondering what the best way to do this is? I had in mind a quick global to query the User table with Username=Review_Owner and return the User ID?

Does anyone have any simple examples of globals that can query a Links table and return a unique value? I've been searching for a while and haven't found anything that I can modify within my Perl abilities .