I am trying to build a parameter based on two fields in my report but having a difficult time. What i want to do is have a parameter that says "Choose Generic Name or Trade Name."  Then depending on which the user chooses, then it would go to either a list of drug names in the generic form or a list of drug names in the trade form (both of those are fields in the report).  I'm not sure if this is even possible but any insight would be very helpful! Thanks!

Well, it isn't a field.... does that make it impossible without creating a new field?

For each drug there is a generic name field and a trade name field.  So for the report we only want to call one of them, depending on which the user chooses, and then from there choose the specific drug(s) to run the report for.

Thank you! That sounds like a good idea!