One to Many Join in True DB

[RSeliga]

Does anyone know of a way to suppress the duplicate rows that are a result of a one-to-many query in a grid?

Say I have TrueDB up with 3 columns. The last 2 columns are on their own split.

So Split 1 contains one column - Name
Split 2 contains City,State

The idea is to have the name print once with all their city/states on the right. ie:

<left split>
Name
------
Joe Blo
<blank cell>
John Doe
<blank cell>

<right split>
City/State
------
Boise, ID
Denver, CO
Baltimore, MD
Santa Fe, CA

Something to that effect. Kind of hard to display in this window. Basically what I'm getting now is Joe Blo and John Doe printing twice on the left column.

Any ideas are welcome. Thx!

Maybe u can group your colums ?
With TrueDB U can
*/
When the DataView property is set to 2 - Group, a grouping area is created above the grid. Until column headers have been moved there/*
So if U like to clear double's you can drag the columns to the grouping area.

Hope You can use this tought.

[RSeliga]

I didnt find exactly what you were referring to in the grid options, but when you said 'group your columns' i started weeding through the help file searching for 'group' and found out that there is a .merge method that does exactly that.

gridname.columns(x).merge = true

works like a champ! i really appreciate your help.

thank you