Hello,
I have a "Search field" looking into "nom_tiers_orga" and 'nom_tiers_contractant"
(1) When I search "Fluo" and click on Fluo as "nom_tiers_orga" I would like Fluo as "nom_tiers_contractant" to be also selected.
I think this can be achieved thanks to a documment trigger?
(2) I need to keep the 2 results even if they are "contradictory" when Fluo is selected for "nom_tiers_orga" and 'nom_tiers_contractant"
I might need to use an 'Union" ?
Can you help please?
| Affaire | nom_tiers_orga | nom_tiers_contractant |
|---|
| PARIS | ORANGE | FLUO |
| NEUILLY | FLUO | VERT |
