Hi Rex,

Couldn't you create your select statement to be executed on the backend that will be create a new DataTable to use to bind to? DataSets are not made to generate select statements using the DataTable contained in it. You need to do that all in the backend.

>All,
>
>In my web application I have 3 tables, EducationalActivities, EducationProviders, and EducationalActivitiesEducationProvidersXRef. As the names may tell you, the XRef is a cross reference table between the Activities and the Providers. I need to display the information as follows:
>
>
> _____ Provider #1
>
> _____ Provider #2
>
> _____ Provider #3
>
> _____ Provider #4
>
> _____ Provider #5
>
> _____ Provider #6
>
>
>With the underscores being text boxes to hold the count for each Provider.
>
>How can I do this?
>
>TIA
>
>Rex