Fred,

Thank you very much. I agree. The only reason I let this field remain is
that the existing database has counters for the two types of students which
populates data in the default form currently being used as a quasi
switchboardt based off an "admin table" which is a query off the main table.
Like I said initially, alot of redundancies!!!

"Fred" wrote:

Brad,

It's quite possible that when you examine your other particulars, you may
find that "status" needn't or shouldn't be a field. E.G. if it is purely
derived from other fields, that derivation could be done when the status info
is needed.