MarKK - I REALLY appreciate the quick response.
Forgive me if this reply is wordy, but I think a data example is easier for me to express than the technology which I quite obviously don't completely understand ...
If I have 3 tables: a table for Schools with a key field School (autonum if you...