Results 1 to 5 of 5
  1. #1
    faca is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    52

    attendance evidence

    Hello!

    I want to create database that would record the attendance.

    Example:
    I have project and this project has more programs. Person can join to one or more programs in one or more projects.

    The intetion of database would be later to see to which projects/programs this person joined..

    I have 3 tables:



    Person (PersonID, Person details...)
    Program (ProgramID,PersonID, ProgramName, StartDate, EndDate)
    Project (ProjectID, ProjectName)

    Relationships:
    Student -> (one-to-many) -> Program
    Project -> (one-to-many) -> Program

    I already tried to make this but everytime i want to add another student to same program (program starts with new id like this would be new program)

    Any suggestion on this?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Here is a free data model re Student Roster. See how he uses the ROSTER table to record attendance.
    The model is generic, you can add, remove or adjust as necessary.
    I realize you aren't dealing with students and courses, but the relationships may be useful to you. I'm suggesting you review it for concepts and ideas.
    Good luck.

  3. #3
    NTC is offline VIP
    Windows 10 Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    You need 1 more table. Generically it is called an intersection table - and in your app you might call it: Participation

    It would have fields: PersonID, ProgramID, ProjectID,

    Your form is sourced to table Participation. You'll have combobox controls sourced to your 3 list tables.

  4. #4
    faca is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    52
    This is not an actual attedance to check whether person came to program every day or not only to check to which he joined..

    Example:
    (At the end of the year ill print report)

    Person 1 joined to:
    - Project Job
    -- Program How to get the job
    -- Program What to do when i find job?

    - Project Car
    -- Program Which car brands do i know?
    -- Program Which car brand should i buy?

    -----------------------------------------------

    Person 2 joined to:
    - Project Car
    -- Program Which car brand should i buy?

    Or if ill check Program Which car brand should i buy? ill get:
    Person 1
    Person 2
    Person 3
    Person 89
    Person 90
    Person 45




    This is what i want to do

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Cross posted here https://www.access-programmers.co.uk...d.php?t=299811

    @Faca - please read this link about the etiquette of cross posting http://www.excelguru.ca/content.php?184

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

Similar Threads

  1. Determine presence of a Table in the Navigation Pane.
    By casinc815 in forum Programming
    Replies: 7
    Last Post: 07-11-2014, 11:57 AM
  2. Replies: 9
    Last Post: 01-20-2014, 12:06 PM
  3. Check for the presence of a picture.
    By sergran in forum Programming
    Replies: 4
    Last Post: 08-08-2013, 09:22 AM
  4. Replies: 7
    Last Post: 02-20-2012, 07:19 PM
  5. Duplicate Register
    By maluna in forum Access
    Replies: 1
    Last Post: 09-28-2010, 12:45 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