How do I create different forms for one table

[sakoni2001]

Hi. Can someone please help me. I have just joined a charity org hosting fund raising events. I am a complete novice at Access.

The org has approx 4500 members. I have loaded that on MS Access which contains various information such as membership number, addresses, date joined, etc.

Every month we hold 3-4 fund raising events. What I need to do is create a simple form where I can input either the members name or membership number and than add the event the member has attended and their contribution. I need that information to be saved in another table.

For example:

On 3rd June, member John (membership number 1001) attended the event and contributed £30.

On 24th June, member Mary (membership number 1368) attended and contributed £15.

Etc

We can than analyze which event a member attended and his contributions so far.

Can I do all this in one database?

Any help will be highly appreciated. Thanks in advance.

 

[wiklendt]

have a table called tblFunctions, where you put in function details, whatever they may be for your org.

have another table called tblContributions. here, have four/five fields (or whatever you need) ContributionID, FunctionID, MemberID, Amount, Notes. MemberID field a lookup back to your Members table. This is a many to many table (M-M)

then, make a form based on the function table (set view as form), and another form based on the M-M table (set view as datasheet).

place the M-M form as a subform in your funciton form. Tell access (when prompted by the wizard) that you want to choose your own relationship, select Function ID from both tables.

Then, when you are detailing the function in the form, all you have to do is select a member from the drop-downlist, and add in their contribution. to add another member, access should have made a new record spot available underneath the one you just filled (b/c it's in datasheet view, it looks a little like an excel table).

 

[sakoni2001]

Hi Wiklendt

Many thanks for that. I will give it a go.

 

[wiklendt]

you can also set the form based on the M-M table as "continuous form" instead of "datasheet".... if you prefer to look at it that way (i prefer datasheet, which is why i suggested it - but it does depend on what data you'll be putting in there etc)...