In Form designer set the following grid properties:
RecordSource = auth (just the alias, not fields)
ColumnCount = 4
Then, go to column1 and set the
ControlSource = auth.organization
Then, go to column2 and set the
ControlSource = auth.authtype
Keep in mind that you need to do this on the form designer.
On the other side, if you decide to do this on the fly (i.e. ColumnCount=-1 at design time, and then ColumnCount=4 at run time) then you need to set the grid RecordSource and the columns ControlSource at run time. Keep in mind that if you change ColumnCount at runtime VFP will recreate the columns and then you will need to reset their properties.
>VFP 6.0
>
>Grid: Grid1
>ChildOrder: main
>LinkMaster: person
>ReadOnly: .T. - True
>RecordSource: auth.organization, auth.authtype, auth.effective, auth.end
>RecordSourceType: 1 - Alias
>RelationExpr: id
>
>How can I specify what fields to show in the gird (ColumnCount: -1), since the rest of the fields would be above it in all the textboxes for add/editing.
>
>Chuck
Hector Correa