Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2007
    Posts
    10

    Unanswered: Design question for table to capture multiple dates

    Morning all,

    I'm attempting to design & write an Access database for an organisation I'm involved with - I'm a software engineer by profession, but weak on databases.

    The requirement is this: I wish to capture availability information for specific people. Everybody within the organisation receives an availability sheet each month and nominates which days they are available. I want to be able to capture it as follows:
    Person A is available on 11/07, 12/07 and 14/08
    Person B is available on 11/07, 12/07, 14/07 and 13/08

    etc. etc.

    The "people" will be stored on a separate table, so a key field will be used to reference to them. I'm stumped on how to efficiently capture the date information, in such a way that I can then extract who's available on what date.

    I'd appreciate any & all assistance and suggestions on this, as it's causing me a bit of a headache.

    Thanks in advance.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    create an "availability" table with two columns: person_id and date

    primary key should be composite, i.e. both columns
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2007
    Posts
    10
    Quote Originally Posted by r937
    create an "availability" table with two columns: person_id and date

    primary key should be composite, i.e. both columns
    Right, I see how that would work. I'll have a go at it.

    Thanks for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •