Jump to content

View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Print one issue for each checkbox value selected

June 16, 200421 yr

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!