Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi,
OR condition on two fields of same table will be not simple
may be concatenate in load the two fields and then search in concatenate field
regards