Schema Definition Question

[Frank A]

Hi,

I have a db handler with the following definition:

            <entity name="place"
                query="select OurID,Name,City,State,lat,lng,cost from place"
                deltaQuery="select OurID from destinations where
OurID= '${dataimporter.request.did}'"
                deltaImportQuery="select
OurID,Name,City,State,lat,lng,cost from place where
OurID='${dataimporter.delta.id}'"
                >

            <entity name="features"
                    query="select label,f.FeatureID from features f,
featureplace fp where fp.PlaceID='${place.OurID}' and
fp.FeatureID=f.FeatureID">
                <field name="featureLabel" column="label" />
                <field name="FeatureID" column="FeatureID" />
            </entity>

In my schema I have:

  <field name="featureLabel" type="string" indexed="true"
stored="true" multiValued="true"/>
  <field name="FeatureID" type="string" indexed="true" stored="true"
multiValued="true"/>

This yields results that have a list of feature labels and a separate
list of FeatureIDs with now real connection between the two.  Is there
a better way to represent this?

Thanks.