Hi
How to set a Table Relation on a line field to get Sum(quantity) from ILE where Item = Line Item and Location = UserId Location
Thanks
*This post is locked for comments
Hi
How to set a Table Relation on a line field to get Sum(quantity) from ILE where Item = Line Item and Location = UserId Location
Thanks
*This post is locked for comments
Table relation is just for the LookUp to any Master Table, You need to go for FlowFields.
You can not build a flowfield where you select filterfields form two different tables. So you will have to create your sum in code and then display it on the page you want to show it.