tracking info from multiple tables in one master tracker

[nbarr]

i am trying to create a database that will track donations for multiple teams
that will use this database. i would like for each team to have their own
table and form to record their donations and for all of the tables to also be
saved in a master tracker that will be a record of all the teams donations
combined. i am not sure how to make the master tracker automatically update
each time a new entry is added in any of the teams individual tables

 

[KARL DEWEY]

Naa, use one table with field to designate team.
Use a team select form that opens on startup to open form for data entry
that team identity based on team selection in startup form.

 

[nbarr]

so if i do that, i would have one table. then i could use a query or a
report for each individual teams donation record?

 

[nbarr]

how would i make the table recognize which team it was based on the form it
was entered from?

 

[KARL DEWEY]

The second form, data entry form, would have hidden text box bound to team
field of the table with default for team selected in first form.

 

[Bob Quintal]

so if i do that, i would have one table. then i could use a query
or a report for each individual teams donation record?

Yes, or even a single parameter query that asks for (or looks up on a
form) the selected team.