Print one issue for each checkbox value selected

[Jacob22x]

I really need some help on this one - I don't even know where to start. I have an issues table - for each issue a certain discipline is selected (Mechanical, Electrical, etc.) and the report that prints out of all the issues sorts by discipline. Now the company wants any one issue to be able to be in multiple disciplines. So if an issue is defined as electrical and mechanical, it will show up once in the mechanical part of the report and again in the electrical, without actually having to have more than one record for the issue. How can I do this?

I changed the discipline field (which, by the way, is just a numerical ID field that looks up from a related table, discipline) to be a checkbox, but I don't know how to make an issue that has mulitple disciplines checked show up multiple times. I figure I need to run some sort of loop in my report script. Any help would be appreciated. thanks!