select record_id from lookup where name = 'JOHN'