Filtering

valkatamake

help me with this please
I have table that i need to filter
Example

TABLE
Code Description Number
AAAA doesn't matter doesn't matter
AAAA
AAAA
BBBB
BBBB
CCCC
CCCC
CCCC
CCCC

form must show me

CODE DESCRIPTION
AAAA
BBBB
CCCC

Belias

http://www.mibuso.com/forum/viewtopic.php?t=22963

JedrzejT

In Code:

rec.SETFILTER(code,'%1|%2|%3','AAAA','BBBB','CCCC');

On Form:

Field | Filter
Code | AAAA|BBBB|CCCC

Belias

JedrzejT wrote:

In Code:

rec.SETFILTER(code,'%1|%2|%3','AAAA','BBBB','CCCC');

On Form:

Field | Filter
Code | AAAA|BBBB|CCCC

[-X
i think he means one line for each code,
like a "SELECT DISTINCT" in sql...

valkatamake

this is not the idea
if i have table "who is entering the building" (for example) and i have

john
adam
adam
adam
john
maria
maria
john

in the table could be milion records but only 5 names and i want to show me only uniques records ...

Belias

ehm...try following the link above...

JedrzejT

](*,) sorry..

garak

in my meaning you need a DISTINCT like under sql. so you can store the data, before viewing, in a tempTable and show than the temp.Table

But, other question: why do you store the data in this style :?: I think here the "Number" is your Primary Key. Why not the Code :?: Whats the reason :?:

valkatamake

keys : Code, Description and last number ...

kine

This "Disctinct" problem is because the data are not normalized. Best is to have separate table where you will add the code each time you create some new entry and the code doesn't exists. Than you can make form over this table and you are done.

It means that you have table with "who enters" but you have second table "People" where you have list all names who ever entered...

valkatamake

at least tell me how to check

If first record = second record
if john = adam ... :?: :-k