Results 1 to 3 of 3
  1. #1
    ozzi77 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jul 2014
    Posts
    1

    Adding list of participants to a Events database

    Hi i'm using Access 2010 and i'm trying to create a form for work that allows users to enter details of events that we run and then enter a list of participants as they book in for the event. I've created a table called Events with the fields EventName, EventDate, StartTime, EndTime, Location and created a form for it with buttons for adding a new event and navigating through exiting ones.
    What i'm stuck on is adding some kind of list where users can type in details of people booking in for the events (name, phone, if they've paid yet etc....) and having a new list each time you add a new event?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,633
    You need a Participants table. One of the fields in this table will be EventID. This will be foreign key that provides a link to the 'parent' record in Events table.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    In addition to June7's comment, this link might be helpful.
    I recommend you hget your tables designed to meet your needs before getting into forms.
    Good luck.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Adding All to List Box
    By brett621 in forum Access
    Replies: 6
    Last Post: 07-01-2013, 05:07 PM
  2. Replies: 3
    Last Post: 05-23-2013, 05:30 PM
  3. Adding events at runtime
    By bonecone in forum Programming
    Replies: 2
    Last Post: 04-13-2012, 02:18 AM
  4. Database Relations between Names and Events
    By flebber in forum Database Design
    Replies: 6
    Last Post: 11-22-2011, 02:01 AM
  5. adding list to a listbox
    By jetrow in forum Access
    Replies: 0
    Last Post: 08-15-2006, 03:36 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums