Hello,

I'm building a report library using ASP.NET and have got it all completed 
with the exception of one page. This page will pull in data from 3 tables 
with roughly the following structure:

reports table
reportID integer
reportTitle string

formulas table
formulaID integer
formulaName string

reportFormula table
id integer
reportid integer
formulaid integer

The reportFormula table associates any given report with one or more 
formulas (one report could have any number of formulas, and one formula 
could belong to any number of reports).

The page I'm building has a dropdownlist control that displays a list of 
all available reports, and a checkboxlist control that displays each 
formula in the formulas table. Here's my question: when the user selects a 
report from the dropdownlist, I want each formula that's currently 
associated with that report to be checked. The user can then associate 
additional formulas with that report (by checking more check boxes) or un-
check checkboxes to remove report/formula associations.

Can someone get me going in the right direction! Thanks in advance for any 
help!

Brian