Double/triple/field search

[Anonymous]

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

[ogautier62]

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