Problem with relating values in two multi value fields

[Torben Honigbaum]

Hello,

I've a problem with relating values in two multi value fields. My documents 
look like this: 

<doc>
  <str name="id">3</str>
  <str name="options">
    <str>A</str>
    <str>B</str>
    <str>C</str>
    <str>D</str>
  <str>
  <str name="value">
    <str>200</str>
    <str>400</str>
    <str>240</str>
    <str>310</str>
  <str>
</doc>

My problem is that I've to search for a set of documents and display only the 
value for option A, for example, and use the value field as facet field. I need 
a result like this:

<doc>
  <str name="id">3</str>
  <str name="options">A</str>
  <str name="value">200</str>
</doc>
<facet> …

I think that this is a use case which isn't possible, right? So can someone 
show me an alternative way to solve this problem? The documents each have 500 
options with 500 related values.

Thank you
Torben