model validates against system values table

James Byrne wrote:

class Party << ActiveRecord::Base

   validate :check_party_type

   def check_party-type      errors.add-to_base("Party type #{self.party_type} is not found.") unless        SystemValue.exists?(:table_name => :parties,                            :table_column_name => :party_type,                            :value_as_char => self.party_type.to_s                            )    end

Comments most welcome.

Your approach is perfectly valid according to me, the only other option I can think of is to have a db trigger that checks the field against another table on insert but then you will not get the nicely formated error string that you are producing now.

hth

ilan