>>>>>>>
>>>>>>>>This should work
>>>>>>>>
>>>>>>>>Form.load
>>>>>>>>
>>>>>>>>use AppointmentTypeSets in 0
>>>>>>>>select AppointmentTypeSets
>>>>>>>>set fields to Colors,FromDate,ToDate,Day,StartTime,EndTime
>>>>>>>
>>>>>>>What is "Set Fields" command?
>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>>>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
Gregory