How to use expressions to check if a value is containted in another table.

[Former Member]

Hello,

I have a flat Material table ("Material_table" with a Mat_ID) and a main table that stores MAT_ID and (e.g) Manufacturer. I DO NOT want to use a lookup table (since I don`t want to use the drop-down boxes), but I want to create a (simple) validation that checks, if the MAT_ID that is entered into field MAT_ID in the main table is contained in the Material table.

This serves as a simple "foreign key" check, checking if a value into a table can be found in another table.

Can anyone post the code that has to be written into the validations-Editor.

The expression in the main table could look something like:

Logically:

Check IF (MAT_ID IS_CONTAINED_IN(Material_table[MAT_ID]) then return true

or something like:

HAS_ANY_VALUES(MAT_ID,Material_table[MAT_ID])

Thanks a lot!

(I couldnt find any solution for that in the forums - We are using MDM 5.5. SP6)

[Former Member]

See thread: "How to create a validation that access another MDM-Table?" in this forum.