Re: Forms 4.5 - Unique Records

add an where clause to your block property rowid in (select min(rowid) from <your_table> group by <column1, column2>)

column1 and column2 are your unique fields HTH
Günter

KRM schrieb:

> Hello.
>
> How would I set up my block so that it only pulls in unique rows of
> data? For instance, in one case, there are 8 rows in the database
> (which are all different from each other), but the fields that I am
> pulling in are not unique, in fact, there are only 2 different sets of
> data. How can I set up the block to disregard the duplicates?
>
> Thanks,
> KRM
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Nov 24 1999 - 12:25:44 CST