Bruce,
Thanks for the idea, I'll have some time later today to try it. A stand
alone form for non class payments I can see working but I would have to have
another form based on tblpayments with the fields you list and have a
subform based on class enrollment to allocate the payment as a parent could
pay make a single payment for two students in different classes.

I've started to build a couple of small basic forms to test the suggestions
I've received in this newsgroup.

Thanks.
Nancy


"BruceM via AccessMonster.com" u54429@uwe wrote in message
news:a438b14053915@uwe...
Actually, I kind of wish I had not suggested a separate table for
non-class
payments, as a single table for all payments/income may be preferable.
Starting from Steve's suggested structure for tblClassPayment, maybe you
could modify it along these lines:

tblPayment
PaymentID (primary key)
FamilyID (linking field)
PaymentDate
PaymentReason (optional)
PaymentMethod (e.g. check/cash)
CheckNum

Each family may make many payments. I don't know if you have gotten to
the
point of making forms, but if you have a Family form you can have a
Payment
subform based on tblPayment. Also, you could build a standalone form
based
on tblPayment for non-class payments. tblPayments would then contain a
listing of all payments for all reasons. FamilyID would default to 0 for
non-
class payments. CheckNum would be 0 for Cash payments. It should be
possible to build a query that lists each check separately, and combines
all
cash payments into a single line (although it would depend on you
depositing
all cash received). I won't go too deep into the options just now.
Anyhow,
the query could be the source for the deposit slip, with no need to store
the
deposited amounts. However, if it is your practice to keep deposit slips,
at
least for a while, if makes sense to store the deposit information, in
which
case you can create a deposit record, then open a recordset based on
tblDepositDetails and add the records that appear in the query. This is
not
nearly as complicated as it may sound, but I will wait to see how you want
to
proceed before I launch into details.

Nomy wrote:
Bruce,
Oh, you're right. I don't really need that kind of pmt detail in the
deposit detail table. All I really need is a date, pmt type, I can get
that info from the class payment tables. I agree with the comments field
in
the deposit detail.

I like the idea of a separate table to list non class payment income. In
fact, the more I think about it, the more I like it. Thank you for
suggesting it.

Thank you again for taking so much time to help.

Nancy

As I understand, a payment is made by the person identified in the
Family
table. It may be for more than one student, in which case it is for a
[quoted text clipped - 77 lines]
Thank you in advanch so much.
Nancy

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201002/1