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