A payment is one thing, and a deposit another. You could have a cash payment
and immediately put the cash to use for something. Deposits and payments may
be related, but it may be that not all payments are deposited. Even if they
invariably are, there are two distinct transactions: you being paid, and you
making a deposit.

You may need to allow for a deposit being something other than a class
payment. I don't know if there are grants, donations, studio rental, or
other sources of income, but if so the suggested model does not allow for
that from what I can tell. The Deposit table may not have a FamilyID in all
cases. You may want a field in the Deposits table to describe the deposit
generally, and subform records only for deposits that are specifically
applied to classes. However, there is another wrinkle if a deposit can be
several payments from several people. Typically a deposit will describe cash
as one line item without breaking it down into the source for each dollar,
then each check is listed separately. You can link all of the information as
needed, but you have to decide how far you want to go down that road.

Are classes defined as a certain number of sessions with a fixed enrollment
on set dates? Or maybe Jazz 1 is offered three times a week, and people who
have enrolled for Jazz 1 may attend any of the three sessions. Or maybe
somebody can purchase ten classes to be used as wanted, or unlimited classes
for a month at a time. The details will have a bearing on how you structure
the database.

Nomy wrote:
Steve, thank you for you detailed response.

Could you help with this. I understand that tblClassPayment is related to
tblClassPaymentDetail by ClassPaymentID and tblDeposit is related to
tblDepositDetail by DepositID using a form and subform for the payments and
deposits. I know you said to put a field called ClassPaymentDetailID in
tblDepositDetail but how will the data from the payment detail table be
posted to the deposit detail table.

Nancy

Hi Nancy,

[quoted text clipped - 111 lines]
Thank you in advanch so much.
Nancy

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