>>>>>>>>
>>>>>>>>>This should work
>>>>>>>>>

>>>>>>>>>Form.load
>>>>>>>>>
>>>>>>>>>use AppointmentTypeSets in 0 && order ...
>>>>>>>>>select AppointmentTypeSets
>>>>>>>>>set fields to Colors,FromDate,ToDate,Day,StartTime,EndTime
>>>>>>>>
>>>>>>>>What is "Set Fields" command?
>>>>>>>>
>>>>>>>>>&& grid.RecordSourceType = Alias
>>>>>>>>>&& grid.RecordSource='AppointmentTypeSets'
>>>>>>>>>
>>>>>>>>>

>>>>>>>
>>>>>>>Come on, Jay ... Look in the help ... It's even included and properly indexed in vfp9sp2
>>>>>>
>>>>>>Screw you. I simply asked what it was. Thanks.
>>>>>
>>>>>You're such a nice boy ..
>>>>
>>>>Yeah, thanks for being so helpful, and your solution only would work if I had no need for any of the other fields on the form. The grid can be set to only use specific fields, but don't you worry about it; I'll get it.
>>>
>>>Then set them back after the DoDefault() of the init of the grid ... which will be instantiated and initialized
>>
>>The issue seems to be that the ControlSource for each column needed to have the Alias removed. So,
>>"MyAlias.Field07" needed to be "Field07" instead. And the RecordSource was ok as "MyAlias" without a need for listing the fields. It works fine now.
>>
>>I see that you removed your line about no simple solution (saw it in Naomi's reply) but it seems that it was. Just a syntax error in the ControlSource.
>
>I did not remove it. I added it
>
>The controlsource for each column does not need the alias removed: "MyAlias.Field07" is fine

Not for mine. If I put the Alias in, no populating of the grid.