on 2023 Mar 20 9:20 AM
Hi,
Here is my problem :
I have the following tables
Product : with PRDID, PRDDESCR, BD (in this table the root is PRDID)
Country : with BD, COUNTRYID, COUNTRYDESCR (in this table BD and COUNTRYID are the root)
and I have a compound MD table (ProductCountry) with
PRDID, COUNTRYID as root attributes and extra attributes (like FLAG1, FLAG2)
When the user opens the master data workbook related to the compound table ProductCountry, I would like that he can visualise also PRDDESCR and COUNTRYDESCR
Is there a way to achieve this ?
Many thanks in advance,
BR,
Jean-Luc
Request clarification before answering.
Hi jeanluchospital,
Firstly, the compound master data ProductCountry should have BD also as Root.
To visualize the PRDDESCR and COUNTRYDESCR in the Compound master data, just add these as Non-Root attribute.
So, the Compound master data (ProductCountry) should look Like:
Key: PRDID, BD, COUNTRYID
Non-Root attribute: Flag1, Flag2, PRDDESC, COUNTRYDESC
Regards,
PJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
4 | |
3 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.