By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,984 Members | 2,615 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,984 IT Pros & Developers. It's quick & easy.

Validation - comparing values from another table

P: 1
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
Oct 11 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
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)
Oct 11 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.