>In a navigation grid I want to show fields from related tables. Can this be done without using a select cmd as record source?
>
>TIA,
>
>Alex

Alejandro,


You can add columns to your navigation grid an set their controlsource to eg RelatedTable.Name

You'll have to open the RelatedTable and set its order to a related key

In addition, you'll have to define a relation (see SET relation command)

sample:

form.load()
use RelatedTable again in 0 order Id
set relation to TableOfGrid.SomeField into RelatedTable in TableOfGrid

grid.init()

local cc

cc= this.ColumnCount + 1
this.ColumnCount = cc
with this.Columns[cc]
.ReadOnly = TRUE
.ControlSource = 'RelatedTable.Name'
.Header1.Caption = 'Name'
endwith