Validation - comparing values from another table

[agiuga]

I am setting up a database of students, examination modules and a results table. Modules have a variety of different maximum marks. eg. one module may have a maximum of 50 while another 60. In the results table how do I ensure the mark input doesn't exceed the maximum possible as given in the module table?

Thanks for your help

[nico5038]

I am setting up a database of students, examination modules and a results table. Modules have a variety of different maximum marks. eg. one module may have a maximum of 50 while another 60. In the results table how do I ensure the mark input doesn't exceed the maximum possible as given in the module table?

Thanks for your help

Just record the max in the modules table.
When calculating the results "top" the sum to the modules max when it's exceeding that value.
By doing this in a query (or function), you're sure that even when a modules max is changed, the reports will show the correct value.

Getting the idea ?

Nic;o)