I have 2 Tables:
Equipment_Site: ID,Make,Model,Serial (anything upto 200 records already filtered to a collection from original Equipment Table)
ClassificationLink: ID,ClassificationID,ForeignID,UserValueText (over 8000 records)
Classificationlink.ForeignID is the join to Equipment_Site.ID
Now As the In Operator is not Delegable (Yes I Know it says it is but its not), i need to find a way to link these tables.
This is what it should be:
LookUp('[dbo].[ClassificationLink]',ForeignID in Equipment_Site_Test.ID And ClassificationID=148,UserValueText)
However this does not work when used in AddColumns to Equipment_Site Collection or anywhere else.
What I can do is put a gallery in, add a text box and set its formula to:
LookUp('[dbo].[ClassificationLink]',ForeignID=ThisItem.ID And ClassificationID=148,UserValueText)
.....but how can i then add this to the collection. Ive tried Patch and forall but cant get it to work.
Any help or another suggestion greatly appreciated, its the 1 stumbling block for my whole app
User | Count |
---|---|
139 | |
132 | |
75 | |
72 | |
69 |
User | Count |
---|---|
214 | |
196 | |
64 | |
62 | |
54 |