Java API find main table record from lookup table reference

[Former Member]

Hi,

Im very new to the MDM Java API and Im trying to find a main table Record from a lookup table value. Whilst the API seems to support this I can be sure but I would like to avoid looping through the entire maintable checking the lookup table field value to get the correct maintable record.

In short:

Main table = Company

Lookup Table = Company Details which includes emailAddress

{tuple not a qualified ref)

I have an email address that resides in company details and I want to find the Main table company record using the email addy. ?

Any reference to a similar scenario on SDN or rough pseudo code would be really helpful..

Can I use the field ID of a tuple field in a FieldSearchDimension to find the record that I want in the main table ?

Thanks in advance.

Edited by: Richard McArthur on May 28, 2010 8:52 AM

[Former Member]

Exposing the MDM API via web services in the web service gernerator proved to be a far easier way to access the data...