Results 1 to 5 of 5

Thread: Matching data

  1. #1
    Join Date
    Mar 2004
    Posts
    52

    Unanswered: Matching data

    Hi,

    I have an appointment table which holds the fields CLASS NAME and CLASS TIME. My question is how do I prevent writing in the wrong time for the class.

    For example - Maths class starts at 9:00.

    Class Name: Maths

    Class Time 9:00

    If the user types 10:00, I want an error message to be displayed.

    Thanks in advance

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Where is this occuring?

    What does your user NEED to be able to do?

    Is this a form?

    What's your table structure?

    Who chooses the times?

  3. #3
    Join Date
    Mar 2004
    Posts
    52
    This is occuring in the Appointments table.

    The user will have to look at what class in running at what time and
    make sure the exact same data is stored when filling out members
    appointment form.

    The receptionist will choose the times.

    I have tried setting up a look up wizard for class time but can not get time to be entered in the time field. It keeps putting in class name.

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I'm confused here..

    There is only one possible time for a class, but you want the user to enter the time twice? And you want to make sure they enter it the same way twice?

    I'm MOST curious as to your table schema...

  5. #5
    Join Date
    Mar 2004
    Posts
    52
    Teddy, you were right to be confused. I would have to describe my whole project to you to explain why I put class time and name in the appointment table. I have removed them now. Thanks for making me aware of the problem....

    That would have cost me marks in my project viva! Thanks Teddy.

Posting Permissions

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