Ravi,

>
>>If you only want one patient name to show for each time slot, then you can use SET ENGINEBEHAVIOR. Or, you could also use MIN(patient_name) to get the first one alphabetically.
>>
>Right now, I have added the only other field in teh select statement and VFP appears to be happy, should I take if ot and place set engine instead?
>

You mean you added the third field to the GROUP clause? Is it working correctly? I would expect it to return more records if you do this...if two people have the same time slot, it will return both.

If you want only one person to show per time slot, you have to SET ENGINEBEHAVIOR, or use MIN(pat_name), MAX(pat_name)...and which ever one of these routes you choose, you would take the patient name out of the GROUP clause.

>>If you want every patient to show, then you can remove the group clause completely.
>>
>In that case, having the Group cluse appears to be useful.

Yes, if you want one record per time slot...but, again, if you add the patient name to the group clause, you will get more than one record per time slot. If you want every record for each time slot, I don't see how the grouping is helping.

>
>I wish there was a way to point the curos on the cell in the grid and it woudl show all the names in that slot for that time, kinda like a tips tool.

There may be a way, but I don't know how. :)