You need a global template to pull out County_Name from Counties table. Here is the code:

sub {
my $id = shift;
my $name = $DB->table('Counties')->select('County_Name', { IDNumber => $id })->fetchrow;
return $name;
}

Now you can use <%global_name($IDNumber)%> in the template

TheStone.

B.