var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Matching data
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
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?
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
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.
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...
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.