Thread: Dance Classes
View Single Post
  #11  
Old February 24th, 2010, 05:03 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Dance Classes

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


"BruceM via AccessMonster.com" u54429@uwe wrote in message
news:a41ca48e96636@uwe...
Steve, I was thinking that a Deposit record is a single deposit event, or
the
filling out of a single deposit ticket, or however you want to look at it.
That being the case, deposit type (cash or check) would be more
appropriate
to the deposit detail. I assume you would still have that table as
described
earlier, although you did not mention it in your latest post.

The way I see it, payment information is recorded in the ClassPayment
table,
which also includes the payment type (check or cash). I think your idea
of
opening a recordset and appending check payments from ClassPayment to
DepositDetail table is a good idea. It would be possible also to append
other information such as FamilyID if necessary, but I wonder if there is
a
reason for recording that level of detail. In a paper-based system a
person
would make a payment, which would be recorded in the appropriate ledger.
The
payments would be entered onto a deposit slip, but I expect in most small
business cases the deposit amount only is noted, not the source of the
specific deposit line item. I don't know what business need would be
served
by going beyond that in an electronic system.

My thinking was that to do most of the work of filling out the deposit
ticket
you could append to the DepositDetail table records of check payments as
you
suggested, then add all cash as a single detail line item, and any other
checks would be input manually. A non-class deposit table may be more
slicing and dicing than is necessary, but the OP may weigh in on that.

Please don't think of this as a challenge to your entire idea. Rather, I
am
suggesting further considerations, including these points:
A payment is made by the Family person, but may be for more than one
student.
Therefore, the payment record would be associated with the FamilyID, but
each
individual Student record would show that the payment was made. Payment
for
two students at once would presumably be a single check, and would be
deposited as such, so any link with the Deposit record needs to be to the
Family record.
The Bank Account table may be a valid consideration, but if there is a
single
bank account it may add an unnecessary layer.
A single deposit ticket for a single bank account should be able to
accomodate deposits from all sources, unless there is a specific business
need to separate class and non-class payments. Again, appending records
to
do most of the work, then inputting additional records manually, could be
a
good solution.

Steve wrote:
Nancy,

Bruce keeps mentioning that deposits other than class payments are not
handled by my proposed tables. He is correct but that was an intentional
ommission. TblDeposit and TblDepositDetail are meant to only record
deposits
of class payments so you will always be able to just track class payments.
If you want to include deposits from other sources, I suggest you need to
revise TblDeposit and add more tables:

TblBankAccount
BankAccountID
BankName
BankAccountNumber
Bank address fields

TblDeposit
DepositID
BankAccountID
DepositDate
DepositType Check or Cash
DepositCheckNum

TblNonClassDeposit
NonClassDepositID
BankAccountID
NonClassDepositDate
NonClassDepositType Check or Cash
NonClassDepositCheckNum

TblNonClassDepositDetail
NonClassDepositDetailID
NonClassDepositID
NonClassDepositDescription
NonClassDepositAmount

If you make these changes, you will be able to determine the total of all
deposits as well as track deposit of class payments and deposit of
non-class
income separately.

Steve, thank you for you detailed response.

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


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