So for argument sake lets assume that what I am trying to do has to be done in a table and without the use of forms (becasue its what works for us) in Access 2007.
I have a table where my staff records a number of different data fields for accounts. I currently have a 3 table relationship...
