Forum Discussion
ADDCOLUMNS and actual values return (e.g. text string)
Greetings: I have a question for the Community as follows: Background: I used an INTERSECT() to generate a single column table that is a return of distinct values of "Type A" that are ...
Is Table1, Table2 and Table3 linked?
Yes, they are linked.
Here's a screenshot of the (actual) relevant model (below). The Three Data Sets being linked are colored and labeled. Balance are shared lookup tables to allow for the tree data sets to talk to one another. T1 contains "Drawings", T5 contains "Deliverables" (each of which contain multiple drawings), and T9 Contains "Needs IDs" (some of which pertain to multiple Deliverables). T1 Drawings link to T5 Deliverabels via T3 which contains both and uses T2 as the lookup between it and T1, and uses T4 as the lookup between it and T5 etc...
- Got it. Do I understand you correctly that for each Value B in Table 2 assigned only one value A? (I.e. pais B-A is unique? )
