Skip to Content
0
Former Member
Mar 04, 2009 at 09:30 AM

Use of Foreign Keys in MDM

51 Views

Hi All,

Is there any mean by which we can use Foreign Keys in MDM.

Sighting an example.

We have 3 table with fields:

Products(Main Table): Material No( UF)

Product Regions(Flat): Marerial No ( Foreign Key),Region: Lookup

Prices(Flat): Material No( Foreign Key),Region: Lookup(Foreign Key),Price Type: Lookup.

How is it possible to achieve the above mentioned scenerio.

And are Foreign Keys same as Unique Fields in MDM.

Thanks

Manish

Edited by: manish gupta on Mar 4, 2009 12:30 PM