Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I was asking to something similar here: Re: Listbox search in more than one field
I have the following fields in a table:
I'd like to have a listbox searching among all those fields, displaying all possible values (only once per value):
Listbox:
2
7
37
10
14
15
37
but with an "and" expression. I mean, If I select 14 and then 37 and 38, it displayed me rows that with those three values. Is it possible??
thanks in advance
Maybe like this:
Transform your cross table to a straight tabe using CROSSTABLE LOAD prefix. Then prepare another table to enable the AND mode list box in the frontend:
INPUT:
LOAD * INLINE [
ID, Code1, Code2, Code3
1, 1,2,3
2, 3,3,4
3, 4,5,6
4, 2,1,5
];
Link:
CROSSTABLE (CodeNo, Code)
LOAD * RESIDENT INPUT;
SELECT:
LOAD DISTINCT ID, Code as AndSelect RESIDENT Link;