Guest_imported
New member
- Jan 1, 1970
- 0
Hi All,
We wanted to use lookup tables in our architect model. these lookup tables have details, which is required by many tables joined to each other. If i am joining this lookup table to all then it will form loop. To avoid loop, i can go for subtype but it will cause creation of many subtypes for lookups. I wanted to have only one set of Lookup tables and wanted to refer from other tables whenever required.
Do any body have any idea of any type of join in architct model, which we can use for lookup table without forming any loop. I tried to use "reference join" but this is taking me to other tables trough lookup tables, which is not desired.
Your valuable suggestions are sincerly welcome.
Thanks in Advance,
Manoj
We wanted to use lookup tables in our architect model. these lookup tables have details, which is required by many tables joined to each other. If i am joining this lookup table to all then it will form loop. To avoid loop, i can go for subtype but it will cause creation of many subtypes for lookups. I wanted to have only one set of Lookup tables and wanted to refer from other tables whenever required.
Do any body have any idea of any type of join in architct model, which we can use for lookup table without forming any loop. I tried to use "reference join" but this is taking me to other tables trough lookup tables, which is not desired.
Your valuable suggestions are sincerly welcome.
Thanks in Advance,
Manoj