Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by Pic, Jul 28, 2006.

  1. Pic

    Pic
    Expand Collapse
    Guest

    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
     
  2. Loading...

    Similar Threads Forum Date
    India Center Accepts Punjab CMs Plea on Black Lists of NRI Sikhs, Deletes 142 Names Breaking News May 15, 2011
    Sikh News Centre removes 23 ex-Khalistani militants' names from blacklist Breaking News Aug 14, 2010
    Punjab wants Center to cut most Skih names on blacklist Hard Talk Jul 22, 2010
    Sikh News How The Left & Indian Nationalists Distorted The History Of Sikh Gadhar Movement - Breaking News Sep 21, 2016
    Interfaith Materialists And Its Discontents Interfaith Dialogues Jun 10, 2016

  3. Mauricio Silva

    Mauricio Silva
    Expand Collapse
    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

    "Pic" wrote:

    > 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
    >
     
  4. Roger Carlson

    Roger Carlson
    Expand Collapse
    Guest

    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



    "Pic" <compuBUTNOTTHIStoot@att.net> wrote in message
    news:4139621najc1ckq411mbe430uch347vb7p@4ax.com...
    > 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
     

Share This Page