Im working on a page that is passed 1 or multiple factility ids.

i take those ids and will display all the facility information in a
datalist. The data will come from 3 tables from a sql server datatbase.

facility table
regulations table
sectors table

a facility can have multiple regulations and multiple sectors.

I would like the report to look something like this

====DATALIST====

facility id reg1
facility name reg2
city reg3
prov ........
POstal Code sector1
latitude sector2
longitude

================

of course this isnt exactly what i want it to look like but its just to
illustrate.
for instance, there could be more or fewer sectors or regulations.

my problem is that im not sure how to show multiple regs and multiple
sectors for a single facility.

i figure ill create a datatable that gets filled from a sqldataadapter.
the datatable will then
get binded to the datalist.

If there was a way to do a sql statment that concatenated all the
regulations for each facility, but that
wouldnt be exactly what i want because i would like to have all the
regulations clickable (hyperlinked to
regulation reports)

Im no expert at datalists or ASP.net 2003 in itself. so if i could get
pointed in the right direction, get some examples or free code, or
anything i would really appreciate it.

someone had to do something like this before. but im totally lost and
have to get this done soon.

well thanks in advance

dave


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!