Question about Validation Rule

[drd0spt]

I have a DBo save existing students on exams,

5 tables:

Students


Courses
Module
Discipline
Registration

on the Registration i have the follow fields to fill:

Course(existent course from the course table) || (lookup field from course)
Student(Existent Student from the student table) || (lookup field from student)
Module(Existent module from the module table) || (lookup field from module)
Discipline(Existent discipline from the discipline table) || (lookup field from module)
Done(yes or no field to know)


i need a validation rule to validate that the same student cant register two times in a row in the same course/module/discipline .

[orange]

Why a Validation rule? Why can't you use some logic in the BeforeUpdate to ensure this.

[John_G]

Hi -

The first question I have is: why can't a student register in the same course/module/discipline more than once? What happens if they fail on the first try? Or is it only twice in a row that they cannot do, but twice with a break in between is OK?

I am also not sure that your table structure is correct - are students able to be in two different disciplines or two different modules at the same time? If you have shown the complete structure of your Registration table, then you need more fields in it I think.

Can you clarify, please?

John

[drd0spt]

Why a Validation rule? Why can't you use some logic in the BeforeUpdate to ensure this.

how do i do that ?

[drd0spt]

Hi -

The first question I have is: why can't a student register in the same course/module/discipline more than once? What happens if they fail on the first try? Or is it only twice in a row that they cannot do, but twice with a break in between is OK?

I am also not sure that your table structure is correct - are students able to be in two different disciplines or two different modules at the same time? If you have shown the complete structure of your Registration table, then you need more fields in it I think.

Can you clarify, please?

John

Well you are right is it possible to put a alert box saying (look you have register for this before)