Bizarre Table Request!

Hi,

First time on here, so hello all!

I have a very strange request from a client who wants to do something simple that they can't because of poor database design (not mine!) . I can't think of an elegant solution so I'm wondering if anyone on here can?

They have multiple tables containing address information, for example they have one containing information about certain buildings. They can use the softcopy of the database to retrieve information about the building but for backup they now need a hardcopy.

Now part of the building information includes the alternative names for buildings (for example "City Museum" and "Art Muesum" might be different names for teh same building). The hard copy needs to have a line entry for both names (proper and alternative) and this is where the difficulty lies.

Using a simple example the table might be:

colour fruit
red apple
orange
yellow banana

The output I would need in the report is therefore:

Red (Apple)
Apple (Red)
Orange ()
Yellow (banana)
Banana (Yellow)

Now I may be being dense but I can't see how I can do this! All help very gratefully recieved :)