gusbrunston
Programmer
I'm ready to design the table(s) for a master journal for escrow accounts for a property manager. If it were you...
1. Would you include a field for the payee/payer's name and address or would you relate the transaction to a table with that information? ...each new payee or payer would be added to the table?
2. Would you include deposits and checks in the same table, or would you separate them?
3. I assume that you would calculate journals for individual beneficiaries of the bank account in forms and reports...or would you? Instead, should there be a table for journals (records) for each beneficiary, and another for journal details (checks, deposits, etc.)?
4. Why do I spend my time re-inventing the wheel. Surely, hundreds, maybe thousands of checkbooks have been programmed. Where could I find one (in Access, of course)?
Your interest in this posting is appreciated, and your contribution will be carefully examined. Thanks a bunch!
Gus Brunston
An old PICKer
padregus@home.com
1. Would you include a field for the payee/payer's name and address or would you relate the transaction to a table with that information? ...each new payee or payer would be added to the table?
2. Would you include deposits and checks in the same table, or would you separate them?
3. I assume that you would calculate journals for individual beneficiaries of the bank account in forms and reports...or would you? Instead, should there be a table for journals (records) for each beneficiary, and another for journal details (checks, deposits, etc.)?
4. Why do I spend my time re-inventing the wheel. Surely, hundreds, maybe thousands of checkbooks have been programmed. Where could I find one (in Access, of course)?
Your interest in this posting is appreciated, and your contribution will be carefully examined. Thanks a bunch!
Gus Brunston
An old PICKer
padregus@home.com
