Not the same case but in the same range : how to apply a criteria on each of the duplicates ?
table t_TIR with fields strMot, IsVerbe, IsFlexion, ID (and other fields)
table t_DEF with PrimaryKey "ID" that make the link with t_TIR (1 to many), from which I extract DEF hereunder.
What I want to track :
strMot | IsVerbe | IsFlexion | DEF |
---|---|---|---|
LURENT | FALSE | FALSE | LURENT --> lire 126. |
LURENT | TRUE | TRUE | LIRE v. 126. |
There could occasionally be more than two records in the duplicate : it is OK to show them as long as the conditions are fulfilled on two of these duplicates.
Kind regards,
Jean-Michel