Bruce and Steve,

Thank you both so much for your valued assistance. Sorry for the delay in
answering but had to leave town for a family matter unexpectedly, and I
didn't have access to a computer and have just returned. I've read the
posts and there are several interesting possibilities.

All the suggestions were excellent and I think it would be good to be able
to track deposits of class payments and non class deposits but I don't think
I need two sets of deposit tables. There is only one bank account and I
think it would be easier to track back if all deposits were together and be
able to identify what kind of deposit it was in addition to cash or check.

If I had a field in the deposit detail table called ClassPaymentDetailID as
Steve suggested in his first answer, then that field would link back to a
class payment after appending the data. Correct? I would then enter the
non class deposits manually as Bruce suggested.

The other side of this coin would be the ClassPaymentDetailID field would be
empty for deposit details that were not class payments. Do either of you
see this as a problem?

I'm going to read through everything again and think it all through very
carefully. I'm not exactly new to access but have been away from it for a
while and have to brush up on a lot. I have never used the VBA code to add
new recordsets so I have my work cut out for me.

I'm excited about doing this project and eager to continue. This newsgroup
is an awesome tool.

Thank you both again for all the help.
Nancy





"BruceM via AccessMonster.com" u54429@uwe wrote in message
news:a41e9005d275e@uwe...
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