i have three tables
PurchLine, InvestTransOrigin, InventTrans
I have made this relationship which I found online
purchline.inventtransid -> inventtransorigin.inventtransid -> inventtransorigin.recid -> inventtrans.inventtransorigin
But this relationship doesn't seem to be working for me because I'm getting empty data.
Can someone please point out where I am going wrong.
How I did it was I made a calculated field in PurchLine
$InventTransOrigin field which had formula:
FILTER(InventTransOrigin,
InventTransOrigin.InventTransId=@.InventTransId
)
Then under $InventTransOrigin
I added another calculated field named $InventTrans which had formula
FILTER(InventTrans,
AND(@.RecId=InventTrans.InventTransOrigin
)
Now for the model binding, i binded my model with Purchjoins(that contains three tables) and binded other fields from Purchjoin.PurchLine
For the fields that i want to bind in my model.
E.g for a quantity in my model
should i bind it with Purchjoin.'$InventTrans'.Quantity
or should i bind it with Purchjoin.PurchLine,'$InventTransOrigin'. '$InventTrans'.Quantity
I'm confused , please help.
16
Share
Report
All responses (
Answers (
