servers_tbl
-----------
 server_id   (autonumber)
 server_name (text)

drives_tbl
----------
 drive_id             (autonumber)
 server_id            (number)
 drv_letter           (text)
 total_disk_size      (number)
 free_space_remaining (number)

##</code><code>##


# lookup the server id
my $server_id = LookupServerID($srv);

$perms_db->Sql ("INSERT INTO $drives_tbl (server_id,drv_letter,total_disk_size,free_space_remaining) VALUES ( $server_id, '$drv_letter', $total_disk_size,$free_space_remaining)");

##</code><code>##

sub LookupServerID
{
    my $serverName = shift;
    my $sql = "select server_id from server_tbl where server_name = '$serverName'"

    #  run the sql through your $perms_db and return the id
    #  you'll probably want to cache these values later...
}