>Hi Shane,
>I see what your trying to do here now. I have one more question for you before I cough up a SQL Select statement that should work...
>
>>For a given IFSP record, there will be 1 to 3 IFSP_SVC records.
>
>What field (other than primary key) makes those 1 to 3 IFSP_SVC records different? I'm suspecting maybe svc_type field has 1-3 possible values here? If so, are those 3 possible values static (or rather set in stone, meaning we could query for each of the 3 possible values and then union the three intermediary result sets together)?
All the other fields can be different, there are about 10 possible svc_type's. This is a record of medical services being given to a child. That child will not receive anymore than 3 services at a time. It all depends on what problems the child has. They may also have different start dates, although they will be within a 6 month period. Thanks for your help.
--Shane