How to make a list of names in a text box?

[Pic]

I have a database that I use to keep track of meetings at my school.
One table (tblMeeting) consists of meeting details: date, place,
duration, subject and a memo field containing a summary.

I'd also like to keep track of who was at each meeting. At present, I
have a separate table of staff member names (tblStaff), but can't
figure out how to use it to create a text box on the form showing a
simple list of those in attendance. As a result that table is useless,
though I feel it shouldn't be.

My workaround has been to create a checkbox field in tblMeeting for
each staffer, which is ticked if that staffer was in attendance. This
is very cumbersome, especially since we have a fair turnaround of
staffers.

Can anyone suggest how I might achieve this?

Thanks in advance,
Pic

 

[Guest]

Hi Pic,

It seems to me a textbox would be just more work when you could use a List
box. Put a list box, set recordsource to grab staff from your meeting, this
should show you a list of attendees.

Mauricio Silva

 

[Roger Carlson]

What you really need is another table. Let's call it tblMeetingStaff. In
that table, you will have the primary key of each of your other tables. For
instance:

tblMeeting tblMeetingStaff tblStaff
======= ========== ======
MeetingID(pk) MeetingID(cpk) StaffID(pk)
.... StaffID (cpk) LastName(etc)

Note: (pk) stands for Primary Key. (cpk) stands for Compound Primary Key

Then you create relationships between these tables as follows:
tblMeeting tblMeetingStaff tblStaff
======= ========== ======
MeetingID------< MeetingID(cpk) |------ StaffID(pk)
.... StaffID (cpk)>----| LastName(etc)

(I hope the formatting comes out right)

Then on your form, create a subform based on tblMeetingStaff. Link
Parent/Child fields on MeetingID to the Main form, and have a combobox in
the subform that chooses the staff member.


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L