Can this be done?

[angiw]

I am pretty familiar with Access, but I haven't used it in a while so
I think my logic is a little off. I'm using Access 2002 with 2000
format.

I want to take a copied list of names and apply everyone on that list
to an event(s).

IE:

25 people attended 2 workshops on 1 day. I want a table/form that
will allow me to select the workshops then paste the list and be able
to print out a report for each person as to what workshops they
attended.

Right now, I have two tables: Names and Workshops. I'm thinking I
have to create a record for each person for each workshop, but that
seems cumbersome to me and there MUST be an easier way to do it.
Please tell me there is!!!

 

[Brian]

Typically, you would create something like this:

Create a table called Attendance. Two fields: Attendee & Workshop.

Make a continuous form that is bound to this table. Two combo boxes in the
detail section, of the same names as the fields above, and bound to the
respective controls. The Row Source of the Attendee combo box is the Names
field from the Names table. The Row Source of the Workshop combo box is the
Workshop field from the Workshops table.

Now, you can open the form and go down the list, pairing each person with
the workshops he attended.

Now, if everyone attended every workshop & you want to pre-populate the form
quickly, you can make a append query in which you drag in each of your two
basic tables (Attendee & Workshop) and append to Attendance without linking
anything. This will create a record for each Attendee to each Workshop - not
a good query for long-term use, but quite useful to populate the Attendance
table with every possible combination of Attendees & Workshops:

INSERT INTO Attendance ( Workshop, Attendee )
SELECT Workshops.Workshop, Attendees.Attendee
FROM Workshops, Attendees;