DataBase - Repeating data in table

Asked By marine8105 via AccessMonster.com

20-Mar-10 07:06 PM

I am trying to start simple and understand some of creating a dbase.  However,
I want to develop a dbase to handle bank statements.  Each client (using ssn)
can have several bank accounts.  I have set up the form to gather the client
info, bank info, and of course the account numbers.  How do I create a form
to allow me to enter deposits, other increases, checks, other decreases,
balance?  I want to gather this information without having to input the ssn
and account number each time.

I am looking to input the account number, which will tie to the client ssn,
and then input the deposits and checks (along with the date of the statement)
for each month over what might be years.  I can then query using dates and
ssn.

Thank you for any help.

Mike ONeil

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201003/1

20-Mar-10 11:56 PM

As you start developing data bases one of the things you want to understand
is info security.
There is no reason to, and a lot of reasons not to, use a social security
number in a database.
Your band records your checks and deposits by your account number not by
SSN. They do that for good reasons.  If SSNs are stored, displayed and
printed they and perhaps your self may be liable if the customer's identity
is compromised.

Read up on the subject and I think you will agree.

Kevin