Skip to Content
0
Former Member
Nov 28, 2006 at 01:24 AM

MDM ----> Does it reduce Redundancy ?

92 Views

Dear MDM Gurus,

I have this requirement wherein .....based on a value in a main table record I need to pull data from a subtable.

Here is an example of the requirement :

Main Table has say 3 fields :

PLANTNR

LOCATION

Country

I have a Subtable for PLANT with the following fields :

PLANTNR

PLANT Description

PLANT Size

PLant Speciality

This subtable has the values say :

PLANTNR DESC SIZE SPECIALITY

PLANT001 PLANT IS 001 5000 SQ FEET CLOSE TO PORT

Now if a main table record has a PLANTNR = PLANT001

it should pull all the PLANT related data from the Subtable along side the main table record.

So my Mainrecord should look something like

PLANTNR LOC CTY PLANT DESC PLANT SIZE PLANT SPECIALITY

PLANT001 001 US PLANT IS 001 5000 SQFT CLOSE TO PORT

Now if the 103rd main table record has a PLANTNR value as PLANT001 it should bring the same info as above.

How do I accomplish this.

Will building a relationship help.If so how to build a relationship.

The idea is to maintain the Plant Data ( Size etc) in only one table and not for every main table record.

Appreciate any inputs.

Thanks.

Hari