Classification in a table with min max of a other table
I have a problem in my application :
I have a table ABSENCE with a number of days and I want fixe a classification by day.
The classification is create in a excel file to move easy the classification max min.
We have for each class an TrancheID that I want put in the table ABSENCE for linked to the table Classification, a text label of the classification, the number of Day maximum of this class, and the minimum of days of this class.
I want for each line of ABSENCE to have the TrancheID that correspond to his class.
You can find my File Excel and my QVW with this post.