>>>>>>
>>>>>>>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.