Skip to Content
0
Former Member
May 15, 2008 at 07:25 AM

Inserting a record in qualified looup table

36 Views

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