Untitled

Access table validation using data from other tables/queries
ALTER TABLE current_goals
ADD CONSTRAINT valid_goal
CHECK (
    goal >= (
            SELECT goal_floor
            FROM min_goals
            WHERE min_goals.category_id = current_goals.category_id
            )
      );

CurrentProject.Connection.Execute strDdl

If CategoryGoalValue == DLookup('MinGoal', 'Goal', 'Goal = ''' & CategoryName & '''') Then
  'Minimum Goal Met
Else
  'Warning - Minimum Goal Not Met
End If