pieniaszek
New member
- Local time
- Yesterday, 19:48
- Joined
- Dec 30, 2008
- Messages
- 8
In managing bank transactions for a small charities group, I initially had a spread sheet which I imported into ACCESS and it has become difficult to track and relate deposit and withdrawal information. I decided to start from the design state, using ACCESS textbooks. I have to keep administrative transactions and charities transactions separate.
The "bank deposit" design has this problem:
If I deposit 5 checks (I scan each first) on one deposit slip, the bank statement will only report the sum. The deposit slip has several unique codes which I can use (collectively) to relate each specific check to that 5 check deposit. I have to distinguish between an 'administrative deposit' and a 'charities deposit'. I need the check number, amount and date from the administrative deposit as input to the members accounts, and need the check number, amount and date from the charities account as input to the unique list of charities.
The combination of bank identification number, date, deposit slip sequence number, and amount should be sufficient to make a single deposit 'non-repeatable', but I don't know how to make that number of variables as Keys.
Any suggestions?
The "bank deposit" design has this problem:
If I deposit 5 checks (I scan each first) on one deposit slip, the bank statement will only report the sum. The deposit slip has several unique codes which I can use (collectively) to relate each specific check to that 5 check deposit. I have to distinguish between an 'administrative deposit' and a 'charities deposit'. I need the check number, amount and date from the administrative deposit as input to the members accounts, and need the check number, amount and date from the charities account as input to the unique list of charities.
The combination of bank identification number, date, deposit slip sequence number, and amount should be sufficient to make a single deposit 'non-repeatable', but I don't know how to make that number of variables as Keys.
Any suggestions?