PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → dificult query
dificult query
Débuté par willy hermans, 24 mai 2016 10:19 - Aucune réponse
Posté le 24 mai 2016 - 10:19
Hello,

I have to combine data from 3 tables

- Documents
- MyKeywords
- Documents_MyKeywords

I want to select a number of keywords in a multi selection table.

1) I want to show the documents accord with ALL the keywords (few results) (AND)
2) I want to show the documents acoord with SOME keywords (a lot results) (OR)

The document_MyKeywords table is automatically generated by WebDev

Is it better to use HFilter and generate a filterstring according the selections ?

How do I start this. Thanks.

Willy Hermans.