keith and tom, thanks for the responses. as per a
suggestion i received via email only, i think i will
be best served by creating a t_note_area table and
linking its primary key, note_area_id into the notes
table -> t_notes.note_area_id.
that way i get keith's benefit of full nomenclature
and i also don't have to limit myself by hardcoding
the area names.
i do exactly this for note_contact, but somehow i
wasn't thinking through this situation the way i
should have been.
thanks to everyone for getting me back on the right track.
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs