I have a program to Order a widget. When they order widgets, they are allowed to pick and choose options for those widgets.
The options are stored as individual records in a SQL table like this:
ProductID OptionID
5 6
5 13
5 101
So, I want my report to show the total list of options as checkboxes, when that value is present in the datasource. Options not selected should be unselected checkboxes.
I'm guessing this will be a subreport, passing in my ProductID. The result would be a datasource with three records. How do i associate these records to trigger checkboxes on my report?
Thanks
I would like to avoid writing my SQL to include record fields for every possible value as the options will change and I'd have to re-write the SQL every time.