Suppressing repeating values in a grid

You'd have to use two tables, in a "parent - child" type relationship.
You'd need a table with all the cities in it, and the other table would have
to have all the rest of the fields (including the city or an ID field that
refers to the city table). You'd then show the city from the parent table,
then the other fields from the child table.

--

Fred
Microsoft Visual FoxPro MVP
Please respond only to the newsgroups so that all may benefit.

Shanice wrote:
> Hi,
>
> I have grid where i want that repeatinig values are only showed
> once.. And
> i want to work directly with the table so a view or cursor is not a
> solution.
>
> Example..
>
> BELGIUM JAN 10
> KURT 20
> GERD 15
> FRANCE PIET 30
> EGYPT ASAI 15
> KINJO 30
>
> anyone an idea how to do this..

--
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 8/12/2003