79651046

Date: 2025-06-03 10:12:08
Score: 5
Natty: 4
Report link

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.
  1. one of the duplicates contains "-->" in DEF, and the value of IsFlexion = False,
    AND
  2. the other duplicate has IsVerbe = True and IsFlexion = True

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

Reasons:
  • Blacklisted phrase (1): regards
  • RegEx Blacklisted phrase (1): I want
  • Contains signature (1):
  • Long answer (-0.5):
  • No code block (0.5):
  • Contains question mark (0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Jean-Michel