I'll wait to see what the OP has to say. If there is a business need to
separate class payments and non-class income, that is one thing, but I am not
going to tell the OP it is necessary to proceed in that way, and it may not
be possible to convince me that parallel tables (rather than a single field
to distinguish the deposit type as needed) are the way to proceed.

I wondered about the business need to associate a specific deposit detail
with a specific payment. Details in my previous posting. Also, I listed
some other considerations. No need to repeat them here.

Again, I will wait for the OP's response. Absent that I see no reason to
continue hashing this out.


Steve wrote:
Having separate deposit tables makes determining the total of all deposits
as well as tracking deposits of class payments and deposits of non-class
income separately very easy. TblBankAccount is necessary to link the two
deposit systems.

Steve

Steve, I was thinking that a Deposit record is a single deposit event, or
the
[quoted text clipped - 100 lines]
Thank you in advanch so much.
Nancy

--
Message posted via http://www.accessmonster.com