Help with basic structuring

I will try and be as concise as I can...

I am trying to create a database for our organization that will keep track of our "Gift Fund". I have a table with all of our personnel that includes all of their basic info with a customer ID field as the PK. I then have a table that is for all of the transactions. Deposits, withdrawls, description, date, customer ID to relate the two tables and transaction ID as the PK.

So we have a table with our personnel and a table to record transactions. Transactions occur anytime we put money in or take money out as well as when one of our personnel becomes a member of this fund by paying their "dues".

I have created a form to update our personnel table. It works fine. I also have a form to enter basic transactions. It also works fine. My problem lies where I try to make a form that will add a member to this fund (which in the personnel table is a yes/no checkbox) at the same time entering this as a transaction. Ideally the form would have the user pick personnel from a drop down list, click the yes/no checkbox making them a member and then entering their "dues" as a transaction.

Ultimately I would like to be able present this info in several dif reports showing all the silly statistics that boss' love to see.

Any help would be appreciated and if I have left out any key info, let me knw and I will be more specific.

bump....help!

[ScottGem]

The way I would do it is to get rid the checkbox, since its redundant. As soon as an employee makes a deposit into the fund (their initial dues), they become a member. To get a list of members you need only join the personnel table to the transactions table.

So all you really need to do is bring up the employee and add the dues transaction.