Thanks Pat,i guess when you see a db that looks de-normalised, it implies that once...at some time,normalisation had been carried out.
Putting the FieldOfficeID in the contacts table is a very very good idea from you....and i think i have been overlooking it. I will give it a go,only that i...