Combine multiple records

  • Thread starter Thread starter Andre Grujovski
  • Start date Start date
A

Andre Grujovski

I have a table with 3 columns. Last Name, First Name,
Amount. There are multiple entries for each name, eg:

Smith, Jane $50
Smith, Jane $100
Smith, Jane $20

My goal is to combine all the individual Name entries into
one record with each amount still appearing separately.

I guess I'm a little confused as to the layout of the DB,
because I don't really see how I can have one unique ID
(Name) and then have an indeterminate number of entries
for that Name. It almost seems like a dynamically
allocated DB, is this possible.
If you could suggest a better way to do this, please let
me know, here's what I'm doing:
I am trying to keep track of all donations to my
foundation and previously had an excel spreadsheet, which
a row would be inserted for each new donation. I feel an
access form is definitely the way to go, but I'm still a
little new at this.
 
You need to have, at least, 2 tables. One for information about the donor
and another to store the multiple donations each donor might make. These
would be laid out something like this:

tblDonors
DonorID
FirstName
LastName
-- other fields for information about a donor

tblDonations
DonationID
DonorID
DonationDate
DonationAmount

You would use the DonorID field in each table as the join between the
tables. You will also need to add some kind of unique index or a check for
duplicate records in tblDonors.

Feel free to post back if you have further questions.
 
Okay, I think I have the general idea of what to do, but I'm still a little
foggy. I have my two tables set up, and created a join between the two
donorID's. Now, I want to setup a form that I can select the appropriate
record by the donor's name, instead of by the donorID. (Does this make
sense). This way, I can quickly find the donor by name, then, if they exist I
can add a donation to existing record, and if they don't exist I want to
establish a new record for them.

I guess I'm a little confused because in my head it seems like the
uniqueness of the database is the donor's name, but I think I need to still
index by the donorID. Not really sure where to go from here.
 
You should be able to create a combobox that is designed to search for a
given record. There is a wizard that will do that for you.
 
Back
Top