Please help. I am trying to make updating a 'confirmation' routine quick and
easily updateable by some one else.

I have 2 tables, one of which I would like to use to confirm data.

tblTitle: tblState:
RecordID RecordID
Title ParentID
State State

Unfortunately, I cannot use a 'real' relationship to define 'tblTitle.State'
using 'tblState'. 'tblTitle' is imported from a text file.

What I would like to do, preferably using only SQL, is to program a field
similar to this expression (using pseudo code) 'St: IIf(tblTitle.State not
included in tblState.State; "«Unrecognized State»"; tblTitle.State)'

So other users can update 'tblState' as necessary to account for changes in
the exported text file, I wish to avoid:
nested IIf without using tblState
additinal VB code to loop through tblState


(A little background, this frontend does, hopefully, every thing but the
data collection for project tracking. Why on earth anyone would make a
'Nice' project tracking software with out reporting more than lists of
records is beyond my comprehension.)

thanks, Rogge