Hey everyone, thanks for looking. I am new to this, although have “looked, and played” with a Lotus approach DB in the past (at an old company, was designed quite well to be honest)
I am trying to put together a " Christmas savings club" database for my father, (they are still using pen and paper, i think they ditched the quills last year.)
Basically, there is a list of people, where they each deposit on a weekly basis, but can withdraw each week if they should need to.
They hand write cards at the end of the year, showing ALL individual deposits/withdrawals… hours of work. I remembered that a report would be able to do this in 1 click, so suggested a DB, and offered to assist. I am literally stumped at the tables, and getting them set up properly…i cannot seem to make them work with what i have tried so far.
I realise i will need a table for people, I have also come to the thinking that i may need separate tables for withdrawals, and deposits, although this could be wrong.
I really do NOT want this to be done for me, as I am actually enjoying the experience of failing miserably. However, some helpful pointers would be GREATLY appreciated.
I feel as though this should be an incredibly simple DB, and cant figure out where i am stumbling.
Thanks in advance,
Adrian H