Foreign Key Relationship

[Former Member]

Hi All,

We currently store Item related information in MDM.

We now have a requirement where we want to store different locations of the item from where it can be ordered in MDM.

Example

Vendor ABC has 5 locations L1, L2, L3, L4 and L5 all of which supply items I1, I2, I3.

Now when a user logs in to SRM and searches for the item I1 from MDM catalog and MDM should show the option of location and force the user to select a location if there are multiple locations.

How can we store this information in MDM so when the user orders he get a choice of the Vendor locations from where he is trying to purchase the item.

Thanks,

Nikhil

[former_member198313]

Hi Nikhil,

Multiple ways are there...Some I can just think of....

You can use qualified tables

you can use simple lookup table (multi value)

You can choose 2 display fields.

Just try the options and choose which meets exact requirement.

Hope it helps,

+ An

• This is not an official message and not related to my organization.