Hi All,
I am using MDM 5.5 SP6. I have table structure like this.
Table name:
Representative (main table)
Fields:
Name Text
Age Integer
Voter ID Text
Gender Lookup[flat]
PostandLocation Lookup[Qualified](Multi-valued) --> It refers qualified table 'Post_and_Location'.
Post_and_Location (Qualified table)
Fields:
Position Lookup[flat]
Location Lookup[Hierarchy](multi-valued) --> It refers hierarchy table 'Locations'
Locations (Hierarchy table)
Fields:
State Lookup[flat]
District Lookup[flat]
City Text
Here, I need add representative details in main table 'representative' using Java API. In webdynpro UI, I will give Name, age,voterid,gender,position, city,district, state.
Here I am struggling that how to lookup hieararchy table value in qualified lookup table(Post_and_Location). How can I achieve this?.Please help me.
I am more happy to give more information regarding this, if anybody needs.
Thanks,
Venkatesh