How to create an accounts table?

[Gman11]

I am currently doing my year 12 (A level/IB) school project.


I am required to do a database which is for a small club (it is a real club)

I have adequate knowledge with access but i have studied on access 2003 but now im using 2010 to create a web database

I have created a members database, including member id, name, amount paid,when the next fee is due, etc.
I have also created an accounts table, but the problem is that i would like it to fill up on its own, as in: when you use the members form and note that the member has paid this is will be noted in the members table but i would also like it to be noted in the accounts table (fields to be noted in the accounts table: member id, name, reciept bumber, date and amount paid) but i would also like it to not change the previous entry for the same member in the accounts table but create a new row for this payment and the previous payment (last year) remain untouched.

This system will also be implemented into other table which i have not created as i would like to make sure that the system will work in the first place

Thank you in advance
Gustav

[June7]

Should not be inputting any payment data into members info table. Data entry should be into a Payments (you called Accounts) table. Each record would be a transaction. Every payment by every member would be input to this table.

[Gman11]

Thank you for your reply but could explain how to do this transaction thing?
Thank you

[June7]

A transaction - payment, refund, credit. I guess you only have payments to be concerned with. Your original post describes correct table structure. A table for member info and a table of records for all payment received. Make these adjustments.
1. Do not put any payment info into members info table
2. Do not put member name into the payments table, only member ID

Build forms as interface for data entry. A simple setup would be a payment entry form. This form would be bound to payments table. Set form to open only to new record. Select user ID from a combobox list, enter payment info.

[Gman11]

Thanks for your help
rely helped a lot and am nearly finished with the whole thing

but i have just come up onto an other problem
i currently have to change my reports (which i created using the report wizard) but i have to now covert them manually to reports which have the globe icon on them (i have do all the reports from scratch using the report button)
that is annoying must the worst part is that when i have a list in my table it shows up as numbers in my report which is not what i want

is there any way to fix this?
or even better is there a way to automatically change these reports to the ones which have a small globe next to their icon? (they are currently completely web compatible they are just missing the globe next to the icon which means that i cannot put them into a navigational form, hence why i need to convert all the reports)

any help will be greatly appreciated

[Gman11]

I have managed to find a solution for my problem