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