Currently, I have a POPULATION list box in my fex so users can choose multiple constituent types. For example:
ALL ALUMNI
ALL DONORS
ALL UNDERGRADUATES
ALL GRADUATES

Now, I want to add majors in my report. In my FEX, I want to combine the following fields into one:

DEGREE.UNDERGRAD_MAJOR_CODE
DEGREE.UNDERGRAD_MAJOR_DESCRIPTION
DEGREE.GRAD_MAJOR_CODE
DEGREE.GRAD_MAJOR_DESCRIPTION

So it will look like this in ONE LIST BOX:
MAJOR_DESCRIPTION (MAJOR_CODE)

So it will list all majors and codes REGARDLESS of if it is UNDERGRAD or GRAD. This way, if someone chooses "Undergrad" and specific majors, it will pull all undergrads with that major. OR if they choose "Alumni" and majors - it will list all alumni with those majors regardless of being a grad or undergrad. The reason why I want to include (MAJOR_CODE) is because some of our majors have OLD codes from an older database that we no longer use, however, alumni still have those codes in the DB and some users want to see the specific codes.

I hope this is clear. Is there a way to combine these fields into one list box? I'm trying to avoid TWO major boxes if a user wants to select both GRAD & UNDERGRAD with 20 different majors selected in each box.

This message has been edited. Last edited by: Kerry,

Consider creating a DEFINE field in your master file that concatenates the two fields together. When you build your dropper select from that field and you should have all the combinations available in your table.

I understand that I can concatenate the major description with the major code fields... but how do I merge DEGREE.UNDERGRAD_MAJOR_DESCRIPTION with DEGREE.GRAD_MAJOR_DESCRIPTION so that there is only one MAJOR_DESCRIPTION?

Create 2 individual hold files for undergrad_major_description and grad_major_description and merge those hold files using FILEDEF. From that you can create a permanent hold file and use that permanent hold file to populate the values into the list box.

You can create a schedule and update that permanent hold file (master file) on a timely basis.

I will try this. Thank you!

You can create two temporary files and use the MORE command to concatenate them.

Thank you, Francis.

I haven't created the HOLD yet, so I'll definitely add the MORE on my list to concatenate.