agent.rb

class Agent < ActiveRecord::Base
	self.table_name = "agtAgents"
	self.primary_key = "agentID"
	
	#has_one :corporation, 	:class_name => "NPCCorporation", :foreign_key => "corporationID"
	belongs_to :inv_name, :foreign_key => "agentID"
	def name
		return self.inv_name.to_s
	end
end

inv_name.rb

class InvName < ActiveRecord::Base
	self.table_name = "invNames"
	self.primary_key = "itemID"

	def to_s
		self.itemName
	end
end

table example rows

agtAgents
agentID divisionID  corporationID locationID  level quality agentTypeID isLocator 
3008416 22          1000002       60000004    1     20      2           0

invNames
itemID    itemName
3008416   Antaken Kamola