I am currently developing a database that allows general ledger account transactions to be recorded. I have set up a general form including subforms that allows the user to input into the account transaction table after chosing an account from the chart of accounts. A further development I would like to explore is the ability to have templates for different sorts of tramsactions ie. automatically specify which GL accounts are affected in the subform based upon a transaction selection in the main form. I guess I would just like someone to let me know if this is feasible in Access.. or whether I should stop wasting my energy. If this is possible.. any hints on going about this is appreciated.

Like with most templates the biggest problem is creating them. Since this is an accounting database I am guessing you are looking to create something like a combo box on the main form with a template name in it which will allow for the dispursement of funds into appropriate accounts.

This is doable but the problem becomes creating a module which will make the templates in the first place and dynamically add them to the combo box. It is doable but can be quite complicated

If you would like to get ahold of me through email we could discuss it more.

[This message has been edited by DES (edited 12-14-2001).]

If I understand where you are going with this, I would use a table. The table would contain the "from" account, and the "to" account as key with a percent field and negative/possitive flag. So if acct1 is distributed to 4 accounts, the distribution table might look like:

acct1, acctA, 5%, +
acct1, acctB, 25%, +
acct1, acctC, 60%, +
acct1, acctD, 10%, +

When a transaction for acct1 is input, you would create as many offsetting entries for other accounts as you find records in the distribution table for acct1.