Working with paradox database.
Posted on 2003-03-01
I am trying to work out grades (A-D) using boundries stored in an paradox table.
I have 2 tables.
Table1: contains field 'Subject' with values English, Maths, Science etc. The other fields in the database are 'GradeA', 'GradeB', 'GradeC', 'GradeD'.
The grade boudries for:
The other table;
Table2: contains a field called 'Grade'.
I want my program to work out the grade (A-D) for any particular subject using the grade boundries for that subject (grade boundires stored in Table1) and then store that grade (whether it is A,B,C,or D) in Table 2 field 'Grade'..
Examples with source code will be appreciated.