Two separate fields need to be grouped in one group

Question

I have two fields: Mother's employer and Father's employer, and I need to group on the employer. Could somebody help me combine the two above fields into one group?

Both fields are in one table. FOr example a child named John Lewis is a record in a table and he has a father and a mother and Mother's employer is IBM and Father's employer is ISF. And so forth. I need to come up with a list By employer where it would show:

It's Crystal. Table format: ID FirstName LastName Mother'semployer Father'semployer 22 John Lewis IBM ISF 23 Tom Frank Lowes IBM 24 Sue Thomas Lowes Turbo 25 Tim Norris ISF Turbo

And I need the results to be the following:

Employer: IBM John Lewis Tom Frank Employer: ISF JOhn Lewis Tim Norris Employer: Turbo Sue Thomas Tim Norris and so forth...... Thank you,

Sigita

Answer 1

You need to specify more information or no one can help you. What's your table structure like for example?