How to design a simple database for charitable donations in MS-Access?

Question

I have been asked to build a simple database for my church. Those using the database will need to use the form view only, so I am trying to make it very user friendly. The church has 3 bank account (checking, savings, and allocated). The allocated account is my problem. This account holds money for 4 separate missions, fundraisers, youth, tithes, food, and music. I need the depositor to be able to go to a form choose an account from a drop down list and if they choose Allocated I need another drop list to be available to show where the funds are going. I can make the list but it will not update my table. No matter which account I choose it sends everything to the Checking account. It has been years since I first learned Access and now even with a couple of how to books I seem lost...any help is welcome.

Answer 1

Microsoft Access has a template for Charitable Contributions that is an option as you create a new database. However, your database will need a bit of customization. In your table of Charitable Contributions, I would have a Bank Account field that can contain the values "checking", "savings", or "allocated". I would also have a field named Missions which would can contain the values "fundraisers", "youth", "tithes", "food", and "music". When the form opens, you can have the form show only the Bank Account drop down box and the Missions drop down box would be invisible. Only if the user selects "allocated" in the Bank Account drop down box, would then Missions drop down box then appear and the user can make a selection.

Answer 2

Hello Kenia, Without seeing your table structure it is hard to say why that is happening. Creating a set of cascading combo boxes is relatively easy. You need to capture the values of each combo box in the account table.

HTH

Jeff